sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
151 36617 1 33   8 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
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)
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)
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)
344 251279 3 76 1200x Hudson Ave 8 1 1 2 3     3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
410 251287 3 20 1299x Hudson Ave 8 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
428 14314 3 15 2190X Market St 8 1 1 2     9 4X4   6003589.1349 2107204.4091 37.766184772649495 -122.430828874247 (37.7661847726495, -122.430828874247)
727 221435 3 109 100x Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 1 Width 3ft   6005438.10251 2108158.21074 37.768908269319795 -122.424501499347 (37.7689082693198, -122.424501499347)
740 26411 3 110 34 Maple St 8 5 1 2     3 10   5996554.84409 2116119.62648 37.7902625562289 -122.45580349675699 (37.7902625562289, -122.455803496757)
829 212194 3 60 720 Bosworth St 8 1 1 2     26 Width 4ft   6002001.778390001 2095479.66425 37.733901344755296 -122.43548039589899 (37.7339013447553, -122.435480395899)
846 175047 3 53 80X Junipero Serra Blvd 8 1 1 2     21 Width 3ft   5991389.20246 2088805.53688 37.714967394312204 -122.47168473357 (37.7149673943122, -122.47168473357)
929 140950 2 60 2060 Ofarrell St 8 1 1 1     23 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
1028 13480 3 15 200X Market St 8 1 1 2     50 4X4   6013615.86639 2116768.91037 37.7930097035807 -122.396818723722 (37.7930097035807, -122.396818723722)
1109 20024 3 5 100 STAIRWAY48 8 1 1 2     12 10ST            
1122 38279 1 52 651 Texas St 8 1 1 1   05/03/2017 12:00:00 AM 3   Permit Number 40367 6013875.32423 2104028.43016 37.7580416558018 -122.39502820678801 (37.7580416558018, -122.395028206788)
1123 28040 1 15 1500 The Embarcadero 8 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011973.34792 2120976.9306 37.8044723526732 -122.40279804081499 (37.8044723526732, -122.402798040815)
1124 29774 3 90 1100X Evans Ave 8 1 1 2   05/03/2017 12:44:00 PM 3 3x3   6018183.3236 2096672.8034 37.7380832156692 -122.37961814277901 (37.7380832156692, -122.379618142779)
1140 6454 3 44 1199 Evans Ave 8 1 1 2   05/03/2017 02:46:00 PM 3 3X3   6017932.4783 2096773.48366 37.738345824884895 -122.380492444782 (37.7383458248849, -122.380492444782)
1192 119753 3 46 101x Octavia St 8 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1209 119800 3 46 201x Octavia St 8 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1307 212207 3 60 920 Bosworth St 8 9 1 2     11     6001467.5944 2095628.72955 37.7342802902926 -122.43733789885 (37.7342802902926, -122.43733789885)
1322 251483 3 3 900 Bosworth St 8 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1370 141258 2 2 51 COMMONWEALTH AVE 8 2 1 1     4 Width 0ft   5996495.6576 2114088.9538 37.7846834760254 -122.455861417999 (37.7846834760254, -122.455861417999)
1395 251525 4 46 173 Sanchez St 8 1 1 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1404 183694 3 48 1341 42nd Ave 8 1 1 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983048.5312 2105875.9885 37.7613521106328 -122.501775383852 (37.7613521106328, -122.501775383852)
1879 221463 3 109 300x Guerrero St 8 11 1 2   06/08/2017 12:00:00 AM 3 Width 3ft   6005505.30672 2106900.54865 37.7654588242817 -122.42417958883301 (37.7654588242817, -122.424179588833)
1889 231241 2 2 2000 Bryant St 8 1 1 1     10 Width 3ft Permit Number 779645 6009524.44231 2105223.15964 37.7610792095625 -122.410159822741 (37.7610792095625, -122.410159822741)
1893 213981 2 77 201 Lobos St 8 1 1 1     1 Width 3ft   5994917.22975 2088691.51162 37.7148577984106 -122.459482208643 (37.7148577984106, -122.459482208643)
1922 14822 3 26 1234 McAllister St 8 1 1 2     12 4X4   6003155.2525 2111726.3545 37.778576329265 -122.432652630798 (37.778576329265, -122.432652630798)
1957 252829 6 161 3852 17th St 8 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1963 140354 2 11 1314 ELLIS ST 8 1 1 1     23 Width 0ft   6004320.8279 2113281.1051 37.7829113213724 -122.42873132198099 (37.7829113213724, -122.428731321981)
2057 202415 2 11 300 Beale St 8 1 1 1   06/19/2017 12:00:00 AM 3 Width 3ft Permit Number 779903 6014884.877230001 2114997.01321 37.7882150346369 -122.39230385636002 (37.7882150346369, -122.39230385636)
2070 109552 2 15 300x Van Ness Ave 8 1 1 1     4 3x3   6006854.31545 2111807.2543900004 37.7790075453087 -122.419861872643 (37.7790075453087, -122.419861872643)
2145 113190 3 2 25 Point Lobos Ave 8 1 1 2   01/19/2016 11:22:00 AM 3 3X3   5982767.26188 2112487.6869200002 37.7794894001028 -122.503237709063 (37.7794894001028, -122.503237709063)
2231 122750 3 94 693 Vermont St 8 1 1 4 2   9     6011285.1392 2105241.4016400003 37.761227830607204 -122.40407158333299 (37.7612278306072, -122.404071583333)
2294 252999 1 73 1201 Tennessee St 8 1 1 1   07/10/2017 12:00:00 AM 3     6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
2332 122438 2 15 598X Folsom St 8 1 1 1     15 4x4 Permit Number 778941 6013622.8347 2114119.5705 37.785735621476 -122.396608809095 (37.785735621476, -122.396608809095)
2355 195025 2 15 300X 02nd St 8 1 1 1     10 Width 3ft   6013739.901380001 2113861.81988 37.7850344122501 -122.396185717917 (37.7850344122501, -122.396185717917)
2400 201838 1 48 350 Friedell St 8 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020663.4716 2092744.71005 37.7274339035298 -122.37077139578501 (37.7274339035298, -122.370771395785)
2409 201824 2 48 100 Friedell St 8 4 1 1   07/12/2017 12:00:00 AM 3 Width 5ft   6021004.603680001 2093212.5880900002 37.728737329640495 -122.369624404053 (37.7287373296405, -122.369624404053)
2412 201597 1 11 451 Donahue St 8 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020830.52372 2093183.4296400002 37.728647714022 -122.37022420239201 (37.728647714022, -122.370224202392)
2415 201596 1 11 501 Donahue St 8 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020816.91369 2093164.12057 37.7285939480275 -122.370269919443 (37.7285939480275, -122.370269919443)
2449 192165 3 32 1500 Mission St 8 1 1 2   09/30/2008 12:00:00 AM 29 Width 4ft Permit Number 779453 6007288.76075 2109818.60353 37.7735716516336 -122.418217917334 (37.7735716516336, -122.418217917334)
2521 141908 2 25 900 MCALLISTER ST 8 1 1 1     12 Width 0ft   6004604.7205 2111934.4347 37.779229760906205 -122.42765319377199 (37.7792297609062, -122.427653193772)
2538 39950 1 180 0 Ervine St 8 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
2546 246846 2 11 301 Broderick St 8 4 1 10     14 Width 3ft   6001207.38463 2109809.38993 37.773202168766105 -122.43925359959101 (37.7732021687661, -122.439253599591)
2549 141907 2 144 900 MCALLISTER ST 8 1 1 1     3 Width 0ft   6004649.797 2111940.7357 37.7792496115336 -122.427497704497 (37.7792496115336, -122.427497704497)
2667 37820 3 48 450X Moscow St 8 1 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003945.80086 2090498.97809 37.7203357084188 -122.428404441018 (37.7203357084188, -122.428404441018)
2729 141998 3 79 818 WEBSTER ST 8 1 1 2   02/23/1990 12:00:00 AM 13 Width 0ft   6003974.6435 2111716.5903 37.778595953895795 -122.42981734758699 (37.7785959538958, -122.429817347587)
2732 27493 3 44 401X Masonic Ave 8 1 1 2   10/04/1999 12:00:00 AM 8 8   5999060.5624 2111177.3019 37.7768357058082 -122.446778158439 (37.7768357058082, -122.446778158439)
2739 253185 2 15 99x The Embarcadero 8 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2766 118353 3 109 100X Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 3              
2793 7815 3 60 700X Franklin St 8 1 1 2     18 4X4   6006205.55902 2112775.31728 37.781629040289005 -122.422174980189 (37.781629040289, -122.422174980189)
2911 140276 2 62 2040 Hayes St 8 1 1 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998008.2541 2109969.0086 37.773457874403704 -122.450331271992 (37.7734578744037, -122.450331271992)
3051 99233 2 59 1111 Columbus Ave 8 1 1 1     12 3x3   6008063.2168 2121048.832 37.8044506767497 -122.416334531861 (37.8044506767497, -122.416334531861)
3077 35211 1 12   8 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
3124 20200 3 26 1300X Steiner St 8 1 1 2   03/24/2005 12:00:00 AM 3 3X3   6002780.7817 2112950.9036 37.78191739001421 -122.434035624824 (37.7819173900142, -122.434035624824)
3131 253310 2 47 2 Euclid Ave 8 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3237 139408 3 13 1500 GEARY BLVD 8 1 1 2   02/12/1999 12:00:00 AM 3 Width 0ft   6004238.7982 2114043.3981 37.7849997446788 -122.429069479335 (37.7849997446788, -122.429069479335)
3313 253405 2 204 1555 Evans Ave 8 7 1 1       3x3   6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3326 230158 3 21 583 Church St 8 1 1 2     6 6x9   6004286.27951 2105638.39668 37.7619243519609 -122.42830596346901 (37.7619243519609, -122.428305963469)
3339 140429 1 59 1499 TURK ST 8 1 1 18     15 Width 0ft   6003096.7102 2112369.578 37.7803391401181 -122.432901115602 (37.7803391401181, -122.432901115602)
3479 8471 3 71 1900 Geary Blvd 8 11 1 2   06/03/1994 12:00:00 AM 6 8   6002124.2891 2113678.9558 37.783879157642104 -122.43635890448 (37.7838791576421, -122.43635890448)
3554 253490 4 31 1x Gordon St 8 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3743 175363 2 12 1 Brotherhood Way 8 17 1 1     3 Width 5ft   5993226.79298 2087801.79474 37.71231750501779 -122.465260429219 (37.7123175050178, -122.465260429219)
3773 228285 8 44 2036X 15th St 8 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3774 99172 1 60 2100 Webster St 8 1 1 1     14 3x3 Permit Number 25928 6003312.12208 2116110.60344 37.7906232670935 -122.432423180296 (37.7906232670935, -122.432423180296)
3904 4665 1 59 600X Columbus Ave 8 1 1 3     100 5X5   6009675.3838 2119664.5956 37.8007404309352 -122.410657649881 (37.8007404309352, -122.410657649881)
3906 253540 3 88 1000 Cayuga Ave 8 13 1 2   10/03/2017 04:11:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3910 14420 3 2 2X Masonic Ave 8 11 1 2     35     5998841.5976 2113071.3194 37.7820236767836 -122.44767199806299 (37.7820236767836, -122.447671998063)
3939 160065 2 48 1000 Cayuga Ave 8 1 1 1   10/04/2017 11:13:00 AM 3 Width 0ft   6000417.53141 2090750.6791299998 37.7208265358932 -122.440618525839 (37.7208265358932, -122.440618525839)
3953 44431 1 49 859 Prague St 8 1 1 1 1 10/04/2017 11:19:00 AM 3   Permit Number 43768 6002228.37284 2086951.06128 37.71049657842789 -122.434087529513 (37.7104965784279, -122.434087529513)
4214 8397 3 47 1500 Geary Blvd 8 11 1 2     18 8   6004036.9348 2113953.0096 37.7847401317276 -122.42976141314301 (37.7847401317276, -122.429761413143)
4326 221448 3 109 200x Guerrero St 8 11 1 2   02/09/2016 12:52:00 PM 1 Width 3ft   6005473.21673 2107488.5662700003 37.767071568632105 -122.42433240701 (37.7670715686321, -122.42433240701)
4412 221475 3 109 400x Guerrero St 8 11 1 2   04/29/2015 10:13:00 AM 1 Width 3ft   6005538.26376 2106334.58706 37.763906688864495 -122.42402534700001 (37.7639066888645, -122.424025347)
4508 253077 3 87 2849X Alemany Blvd 8 1 1 2   10/13/2017 11:16:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4526 221501 3 109 600x Guerrero St 8 11 1 2   02/21/2015 11:08:00 PM 2 Width 3ft   6005604.17413 2105138.97106 37.7606275304574 -122.423712366728 (37.7606275304574, -122.423712366728)
4573 142546 3 26 301 FRANCISCO ST 8 1 1 4   03/26/2016 09:47:00 AM 23 Width 0ft   6009592.8375 2121191.8795 37.8049293448711 -122.411051233847 (37.8049293448711, -122.411051233847)
4587 129651 1 55 2210 Stockton St 8 1 1 1   07/29/2005 12:00:00 AM 2 Width 3ft   6009800.43185 2121827.80217 37.8066870690198 -122.410377757248 (37.8066870690198, -122.410377757248)
4610 129875 3 11 2051 Beach St 8 1 1 10   01/20/2015 12:00:00 AM 3 Width 4ft Permit Number 771149 6000472.54237 2120960.44245 37.8037782163629 -122.44259630138399 (37.8037782163629, -122.442596301384)
4657 24332 3 60 600X Golden Gate Ave 8 1 1 2   01/22/1999 12:00:00 AM 9     6006393.27479 2112527.98365 37.7809605085733 -122.421508000714 (37.7809605085733, -122.421508000714)
4752 95757 3 11 260 Madrid St 8 1 1 4 2 10/25/2017 04:33:00 PM 3 3x3 Permit Number 767495 6003435.4103 2092233.1677400002 37.725068513899295 -122.430292354528 (37.7250685138993, -122.430292354528)
4785 18290 3 37 2000 Post St 8 1 1 2   03/10/1992 12:00:00 AM 6 4X4   6002339.9537 2114048.2121 37.784905293391795 -122.43563921223101 (37.7849052933918, -122.435639212231)
4806 188473 2 97 255 12th St 8 1 1 1     25 Width 5ft   6007942.65601 2109006.33264 37.771378132318894 -122.415898458759 (37.7713781323189, -122.415898458759)
4847 76692 2 2 423 Burrows St 8 1 1 1 1 04/08/1988 12:00:00 AM 13     6010109.0 2093148.0 37.7279562025478 -122.407286823302 (37.7279562025478, -122.407286823302)
4913 97358 1 17   8 14 1 1                    
4992 253754 4 11 2x Rhode Island St 8 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
4997 253742 4 11 1 Henry Adams St 8 1 1 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5012 189150 3 48 351 Cargo Way 8 1 1 2   04/10/2017 11:46:00 AM 3 Width 3ft   6017356.8528 2098625.87133 37.7434003277556 -122.382611554189 (37.7434003277556, -122.382611554189)
5028 253730 3 15 350 Girard St 8 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5040 3573 1 11 100X Cargo Way 8 1 1 9   04/10/2017 09:44:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
5080 3703 3 11 401X Cargo Way 8 1 1 2   05/03/2017 11:47:00 AM 3 3X3   6016493.62964 2099288.69001 37.7451725668523 -122.38564257345399 (37.7451725668523, -122.385642573454)
5122 152419 3 109 700x Guerrero St 8 11 1 2     0 Width 3ft   6005637.900330001 2104551.94757 37.7590176055009 -122.423553987148 (37.7590176055009, -122.423553987148)
5240 8038 3 26 555 Fulton St 8 1 1 2   09/18/2015 12:00:00 AM 12 3X3   6005189.4271 2111616.4778 37.778389785584295 -122.425607814865 (37.7783897855843, -122.425607814865)
5294 97730 3 2 1150 Francisco St 8 1 1 4 2   6 3x3 Permit Number 50638 6005803.34745 2120703.57786 37.8033753605476 -122.424130448959 (37.8033753605476, -122.424130448959)
5300 42638 3 11 1651 Union St 8 1 1 4 2 06/22/2016 02:49:00 PM 3 5x5 Permit Number 42688 6005231.45083 2118842.40752 37.7982327574016 -122.425976953174 (37.7982327574016, -122.425976953174)
5313 13978 3 15 1150X Market St 8 1 1 2     12 4x4   6008898.3811 2112273.9061 37.7804038025089 -122.412823601853 (37.7804038025089, -122.412823601853)
5341 19786 3 22 100 STAIRWAY19 8 1 1 2     6 50ST            
5350 28646 3 35 1600X Webster St 8 11 1 2     8 6   6003557.7645 2114374.9896 37.7858716371659 -122.431449317827 (37.7858716371659, -122.431449317827)
5433 8620 3 1 2600 Geary Blvd 8 11 1 2     6 20   5999320.4644 2113220.5634 37.7824608186771 -122.446026081758 (37.7824608186771, -122.446026081758)
5467 27939 1 100 500X The Embarcadero 8 11 1 9     36 4X4   6013788.66429 2118525.16075 37.7978415693921 -122.396343981507 (37.7978415693921, -122.396343981507)
Powered by Datasette · Query took 4.421ms · Data source: data.sfgov.org