sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14 196590 4 9 43 Lafayette St 2 4 1 1     10 Width 3ft Permit Number 772992 6007565.6944699995 2109618.27361 37.773037177355796 -122.41724576098301 (37.7730371773558, -122.417245760983)
15 196591 4 9 43 Lafayette St 3 4 1 1     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782)
30 196592 4 9 43 Lafayette St 4 4 1 1     8 Width 3ft Permit Number 772992 6007533.59843 2109642.31042 37.7731013709756 -122.41735848920901 (37.7731013709756, -122.417358489209)
62 239043 2 9 10 12th St 2 1 1 1     13 Width 3ft   6006946.59098 2109912.5632700003 37.773810376676295 -122.41940820332898 (37.7738103766763, -122.419408203329)
99 7992 1 9 2247 Franklin St 1 1 1 1   02/01/2007 12:00:00 AM 3 3X3   6005467.69382 2117725.44397 37.7951792074025 -122.42507996488001 (37.7951792074025, -122.42507996488)
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)
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)
324 244302 3 9 350 Octavia St 5 1 1 2     4 Width 0ft   6005598.2085 2110574.7953 37.775552668496104 -122.424119585265 (37.7755526684961, -122.424119585265)
331 244290 3 9 201 Octavia St 2 1 1 2     4 Width 0ft   6005571.2897 2110005.1565 37.7739870584615 -122.424172183065 (37.7739870584615, -122.424172183065)
332 244303 3 9 350 Octavia St 6 1 1 2     3 Width 0ft   6005595.8477 2110592.7369 37.775601798483 -122.42412902808998 (37.775601798483, -122.42412902809)
335 244346 3 9 300 Octavia St 1 1 1 2     4 Width 0ft   6005627.7176 2110356.4274 37.77495474924589 -122.42400197393101 (37.7749547492459, -122.424001973931)
336 244304 3 9 350 Octavia St 7 1 1 2     4 Width 0ft   6005592.0705 2110609.2621 37.775646959405705 -122.42414326985501 (37.7756469594057, -122.424143269855)
338 244347 3 9 300 Octavia St 2 1 1 2     4 Width 0ft   6005625.3569 2110371.5361 37.774996100795995 -122.424011214757 (37.774996100796, -122.424011214757)
487 85532 3 9 101X 12th St 4 1 1 2   05/29/2007 12:00:00 AM 6     6007270.64018 2109417.23244 37.7724685621036 -122.418252136526 (37.7724685621036, -122.418252136526)
624 70356 2 9 1912 Polk St 1 1 1 1 1 05/07/1994 12:00:00 AM 5     6006535.5562 2117410.9094 37.7943758388735 -122.42136264060801 (37.7943758388735, -122.421362640608)
657 5214 3 9 835 Divisadero St 1 1 1 1 4 12/09/2001 12:00:00 AM 3 3X3   6001489.0793 2111327.2763 37.7773859294292 -122.438387950593 (37.7773859294292, -122.438387950593)
735 24812 3 9 2425 Fillmore St 1 1 1 2   07/12/1996 12:00:00 AM 5 3X3   6002709.02465 2116620.06864 37.7919879109555 -122.434546304291 (37.7919879109555, -122.434546304291)
776 196857 1 9 487 Tehama St 1 1 1 1     2 Width 3ft   6010733.79239 2111871.68352 37.7794022433647 -122.406445673949 (37.7794022433647, -122.406445673949)
906 238924 1 9 1362 South Van Ness Ave 1 1 1 1   09/12/2016 12:00:00 AM 1 Width 3ft Permit Number 777634 6007680.96975 2101719.66165 37.751355903252 -122.41628746589 (37.751355903252, -122.41628746589)
936 136112 3 9 90x Jones St 2 1 1 2   11/19/2005 12:00:00 AM 4 Width 4ft   6009117.58988 2112797.33195 37.7818533069147 -122.412102255814 (37.7818533069147, -122.412102255814)
974 238894 3 9 1169 South Van Ness Ave 1 1 1 2   03/01/2007 12:00:00 AM 3 Width 3ft   6007686.52324 2102853.55253 37.7544696223947 -122.416348565858 (37.7544696223947, -122.416348565858)
980 22300 3 9 5000 03rd St 1 1 1 2     3 3x3   6014732.2229 2094948.8267 37.7331585757016 -122.391429927203 (37.7331585757016, -122.391429927203)
985 97601 3 9 855 Divisadero St 1 1 1 1 4   3 3x3   6001476.9066 2111398.2834 37.7775802046297 -122.43843514847099 (37.7775802046297, -122.438435148471)
998 106624 2 9 156 Commonwealth Ave 3 1 1 1     9 3x6 Permit Number 778450 5996579.9247 2113340.3647 37.78263288517989 -122.455515759177 (37.7826328851799, -122.455515759177)
1040 7083 1 9 1790 Fell St 1 1 1 1     3 3X3   5998868.4415 2109744.0912 37.772889499766606 -122.447339580133 (37.7728894997666, -122.447339580133)
1170 238923 3 9 1358 South Van Ness Ave 2 1 1 2   03/01/2007 12:00:00 AM 8 Width 3ft   6007679.38316 2101739.54997 37.751410422860296 -122.41629436101101 (37.7514104228603, -122.416294361011)
1359 196907 2 9 351 Clementina St 2 1 1 1     2 Width 2ft   6011780.0 2112595.0 37.7814467742932 -122.40287726647301 (37.7814467742932, -122.402877266473)
1422 196745 1 9 1201X 08th St 1 1 1 1   05/21/2002 12:00:00 AM 5 Width 3ft Permit Number 45465 6012738.02923 2107105.72844 37.7664279283277 -122.399177491654 (37.7664279283277, -122.399177491654)
1427 196746 2 9 1201x 08th St 2 1 1 1     2 Width 3ft   6012720.73761 2107120.44123 37.7664673626982 -122.399238333493 (37.7664673626982, -122.399238333493)
1488 28091 1 9 550 Divisadero St 1 1 1 1   05/06/2002 12:00:00 AM 3 3x3   6001688.8969 2110354.8179 37.7747271663388 -122.437627056778 (37.7747271663388, -122.437627056778)
1522 251579 3 9 7 Richards Cir 2 1 1 2       Width 3ft   6016313.63012 2095884.37873 37.735815058901 -122.386027719813 (37.735815058901, -122.386027719813)
1534 196952 3 9 7 Richards Cir 1 1 1 2     15 Width 3ft   6016313.63012 2095884.37873 37.735815058901 -122.386027719813 (37.735815058901, -122.386027719813)
1541 196583 2 9 375 07th St 5 4 1 1     7 Width 3ft   6010636.210390001 2110621.8756 37.7759651028325 -122.406695151275 (37.7759651028325, -122.406695151275)
1544 196581 3 9 375 07th St 3 4 1 2     10 Width 3ft   6010649.28152 2110608.88242 37.77593015789721 -122.40664901875 (37.7759301578972, -122.40664901875)
1552 196579 3 9 375 07th St 1 1 1 2     12 Width 3ft   6010663.40725 2110593.10143 37.775887617266605 -122.406599041617 (37.7758876172666, -122.406599041617)
1554 196582 2 9 375 07th St 4 4 1 1     8 Width 3ft   6010641.65206 2110616.23142 37.7759499096844 -122.40667592917801 (37.7759499096844, -122.406675929178)
1558 196580 3 9 375 07th St 2 1 1 2     6 Width 3ft   6010653.5672 2110601.04867 37.7759088880156 -122.406633641224 (37.7759088880156, -122.406633641224)
1856 196887 3 9 117 06th St 1 1 1 2   10/30/2015 02:46:00 PM 3 Width 4ft   6010241.60385 2112346.00757 37.7806770791096 -122.408181831346 (37.7806770791096, -122.408181831346)
2092 196948 2 9 3536 Jennings St 4 2 1 1     3 Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
2146 87638 3 9 7600 Geary Blvd 1 1 1 2     3 3x3   5983555.0 2112529.0 37.779649107322506 -122.50051568716002 (37.7796491073225, -122.50051568716)
2197 24571 1 9 2252 Fillmore St 1 1 1 1   07/12/1996 12:00:00 AM 5 3X3   6002831.271980001 2116073.36845 37.7904937512412 -122.434084229923 (37.7904937512412, -122.434084229923)
2235 238906 3 9 814 South Van Ness Ave 1 1 1 2   03/01/2007 12:00:00 AM 8 Width 3ft   6007504.98766 2104898.95905 37.7600756291027 -122.41712128944201 (37.7600756291027, -122.417121289442)
2484 5197 3 9 631 Divisadero St 1 1 1 1 4 05/10/1993 12:00:00 AM 3 3X3   6001585.1623 2110622.5519999997 37.7754563984119 -122.438005076955 (37.7754563984119, -122.438005076955)
2490 119764 3 9 101X Octavia St Frontage West 6 1 1 2       4x4            
2496 119765 3 9 101X Octavia St Frontage West 7 1 1 2       4x4            
2509 119763 3 9 101X Octavia St Frontage West 5 1 1 2       4x4            
2591 136074 3 9 2401 Fillmore St 1 1 1 2   07/12/1996 12:00:00 AM 26 Width 4ft   6002725.26696 2116528.42543 37.7917372042589 -122.43448355047701 (37.7917372042589, -122.434483550477)
2592 136073 3 9 2411 Fillmore St 1 1 1 2   07/12/1996 12:00:00 AM 7 Width 4ft   6002715.712669999 2116586.15023 37.79189515937421 -122.434520737442 (37.7918951593742, -122.434520737442)
2634 7336 3 9 2100 Fillmore St 1 1 1 2   03/22/2016 12:00:00 AM 3 3X3 Permit Number 777018 6002905.15105 2115557.99031 37.789082847149 -122.43379176139601 (37.789082847149, -122.433791761396)
2641 37818 3 9 450X Moscow St 6 1 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003946.32629 2090524.4735599998 37.720405743114 -122.428404441023 (37.720405743114, -122.428404441023)
2647 37826 3 9 450X Moscow St 14 1 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003896.37457 2090444.78719 37.7201841150858 -122.42857143074801 (37.7201841150858, -122.428571430748)
2652 37819 3 9 450X Moscow St 7 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003953.55423 2090513.34715 37.7203756014419 -122.428378663762 (37.7203756014419, -122.428378663762)
2654 37821 3 9 450X Moscow St 9 1 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003927.902969999 2090495.79555 37.720325957053596 -122.428466081444 (37.7203259570536, -122.428466081444)
2660 37827 3 9 450X Moscow St 15 5 1 4 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003888.33038 2090432.03853 37.7201486548235 -122.428598328547 (37.7201486548235, -122.428598328547)
2929 28092 3 9 528 Divisadero St 1 1 1 1 4 05/12/2001 12:00:00 AM 3 3X3   6001704.4418 2110256.1887 37.774457239071104 -122.43756621922199 (37.7744572390711, -122.437566219222)
2999 141643 3 9 705 DIVISADERO ST 2 1 1 1     3 Width 0ft   6001547.0457 2110892.7785 37.7761962047839 -122.43815629312599 (37.7761962047839, -122.438156293126)
3007 253279 2 9 201X Laguna Honda Blvd 1 9 1 2       10x10 ROW IS 10' tree is street tree          
3014 141613 3 9 705 DIVISADERO ST 1 1 1 1     3 Width 0ft   6001544.5033 2110907.0163 37.7762351536088 -122.43816610813299 (37.7762351536088, -122.438166108133)
3054 7358 3 9 2318 Fillmore St 1 1 1 2   05/19/1992 12:00:00 AM 6 3X3   6002802.77917 2116286.9525200003 37.791078581270106 -122.434198088572 (37.7910785812701, -122.434198088572)
3211 239952 1 9 2900 21st St 1 1 1 1   07/05/2000 12:00:00 AM 5 Width 3ft Permit Number 42822 6008805.731790001 2103926.75101 37.7574792557704 -122.412553896246 (37.7574792557704, -122.412553896246)
3254 244746 2 9 98 12th St 1 2 1 1     15 Width 3ft   6007069.86029 2109755.10428 37.7733849739584 -122.418970623803 (37.7733849739584, -122.418970623803)
3626 5935 3 9 1357 Eddy St 1 1 1 2     6 4X4   6003980.6032 2112841.5446 37.7816851365454 -122.429876994211 (37.7816851365454, -122.429876994211)
3651 240097 1 9 114 Henry St 1 1 1 1   12/15/1992 12:00:00 AM 7 Width 3ft Permit Number 31402 6002724.24367 2107408.57095 37.766696310316796 -122.433834955823 (37.7666963103168, -122.433834955823)
3710 240036 2 9 4121 18th St 2 1 1 1     13 Width 3ft   6002205.0 2105251.0 37.7607426677704 -122.435476567852 (37.7607426677704, -122.435476567852)
3798 5199 3 9 643 Divisadero St 1 1 1 1 4 06/29/2007 12:00:00 AM 3 3X3   6001573.1748 2110709.1284 37.7756934337528 -122.43805274745701 (37.7756934337528, -122.438052747457)
3877 38690 1 9 1529 Grove St 1 1 1 1 1 12/02/2013 12:00:00 AM 8 6x5 Permit Number 40603 6000458.9819 2110614.4446 37.7753700290705 -122.441900209231 (37.7753700290705, -122.441900209231)
3897 253589 2 9 365x 06th St 2 1 1 1       Width 3ft   6011360.0 2111196.0 37.7775819849571 -122.404231777509 (37.7775819849571, -122.404231777509)
3905 196577 2 9 365x 06th St 1 1 1 1     5 Width 3ft   6011360.0 2111196.0 37.7775819849571 -122.404231777509 (37.7775819849571, -122.404231777509)
3984 102394 2 9 30X Harriet St 7 1 1 1     3 3x3   6010499.119030001 2111685.94424 37.778879115810795 -122.407244414896 (37.7788791158108, -122.407244414896)
3998 159324 2 9 516 Ellington Ave 1 1 1 1   10/05/2017 10:39:00 AM 3 Width 0ft   5998061.98233 2087178.88925 37.710884802276205 -122.44850380581998 (37.7108848022762, -122.44850380582)
4015 159294 2 9 118 Whipple Ave 1 1 1 1   10/05/2017 02:12:00 PM 3 Width 0ft   5998151.37307 2087303.3135799998 37.7112315538724 -122.44820380548799 (37.7112315538724, -122.448203805488)
4025 159222 2 9 384 Ellington Ave 1 1 1 1   10/05/2017 09:28:00 AM 3 Width 0ft   5998624.92984 2087716.64467 37.712393528324206 -122.446596800611 (37.7123935283242, -122.446596800611)
4042 179821 2 9 364 Ellington Ave 1 1 1 1   10/05/2017 10:07:00 AM 3 Width 2ft   5998698.94465 2087786.79601 37.712590375508796 -122.446346027354 (37.7125903755088, -122.446346027354)
4052 102393 2 9 30X Harriet St 6 1 1 1     3 3x3   6010484.4318 2111700.90158 37.7789193631694 -122.407296278794 (37.7789193631694, -122.407296278794)
4087 159329 2 9 556 Ellington Ave 1 1 1 1   10/05/2017 11:09:00 AM 3 Width 0ft   5997921.94288 2087046.44589 37.7105131349458 -122.448978278232 (37.7105131349458, -122.448978278232)
4104 159219 2 9 366 Ellington Ave 1 1 1 1   10/05/2017 09:32:00 AM 3 Width 0ft   5998673.37335 2087760.7240000002 37.7125173271842 -122.446432534932 (37.7125173271842, -122.446432534932)
4119 159216 2 9 326 Ellington Ave 1 1 1 1   10/05/2017 10:09:00 AM 3 Width 0ft   5998830.44796 2087909.1779599998 37.712933918350394 -122.445900308946 (37.7129339183504, -122.445900308946)
4129 216706 2 9 231 Faxon Ave 1 2 1 1   10/06/2017 08:40:00 AM 3 Width 3ft   5994712.86869 2090137.86358 37.718817384787606 -122.460293291921 (37.7188173847876, -122.460293291921)
4175 244050 2 9 400 Cole St 4 1 1 1     11 Width 0ft   5997945.2406 2109187.6851 37.771308954489 -122.45049290616699 (37.771308954489, -122.450492906167)
4230 244048 2 9 400 Cole St 3 1 1 1     12 Width 0ft   5997950.1933 2109141.0477 37.771181183618395 -122.45047241196801 (37.7711811836184, -122.450472411968)
4233 244049 2 9 400 Cole St 2 1 1 1     11 Width 0ft   5997947.3042 2109165.8109 37.7712490116574 -122.450484190924 (37.7712490116574, -122.450484190924)
4401 239088 4 9 3855 26th St 1 1 1 2     13 3x3 Permit Number 780732 6004794.15723 2100737.4007099997 37.748496089721996 -122.426200479689 (37.748496089722, -122.426200479689)
4410 24569 1 9 2325 Fillmore St 1 1 1 1   03/28/2001 12:00:00 AM 4 3X3   6002751.62684 2116304.73966 37.7911245168302 -122.43437634589199 (37.7911245168302, -122.434376345892)
4425 97577 3 9 628 Divisadero St 1 1 1 1 4   3 3x3   6001652.1221 2110620.3263 37.775454094869296 -122.43777328811301 (37.7754540948693, -122.437773288113)
4599 100201 1 9 255 Golden Gate Ave 1 1 1 1     3 3x3 Permit Number 51875 6008346.927130001 2112747.04212 37.7816719523255 -122.414764839028 (37.7816719523255, -122.414764839028)
4717 240016 2 9 6 Ford St 1 1 1 1     11 6x6   6003449.63845 2105676.77669 37.7619823582336 -122.431202314632 (37.7619823582336, -122.431202314632)
4739 3036 1 9 2607 California St 1 1 1 1     8 3X2   6001811.8813 2115314.7838 37.7883529667295 -122.437556903926 (37.7883529667295, -122.437556903926)
4894 90500 3 9 339 25th Ave 1 1 1 2   10/21/2016 12:00:00 AM 3 3x3   5988049.93279 2113689.95178 37.783099590598 -122.48505116522 (37.783099590598, -122.48505116522)
4903 239064 3 9 68 12th St 3 2 1 2   10/31/2016 12:00:00 AM 3 Width 3ft   6007045.28032 2109725.44965 37.77330216528821 -122.41905354577699 (37.7733021652882, -122.419053545777)
5125 97583 3 9 748 Divisadero St 1 1 1 1 4   3 3x3   6001590.7259 2111040.5 37.776604295001 -122.438015775508 (37.776604295001, -122.438015775508)
5177 213769 2 9 901 Chenery St 1 1 1 1     1 Width 3ft   6001465.0 2095917.0 37.735071666753 -122.437367503603 (37.735071666753, -122.437367503603)
5188 158290 3 9 901 Chenery St 4 1 1 2     0 Width 0ft   6001465.0 2095917.0 37.735071666753 -122.437367503603 (37.735071666753, -122.437367503603)
5389 27381 3 9 2540 Hyde St 3 1 1 2     12 2X3   6006997.70161 2121072.6946 37.8044562233376 -122.42002354287901 (37.8044562233376, -122.420023542879)
5405 24573 3 9 2100 Fillmore St 2 1 1 2   03/22/2016 12:00:00 AM 3 3X3 Permit Number 777018 6002899.36519 2115591.06429 37.789173331540006 -122.43381414462799 (37.78917333154, -122.433814144628)
5608 106622 2 9 156 Commonwealth Ave 1 1 1 1     9 3x6 Permit Number 778450 5996579.2478 2113322.09 37.78258266885771 -122.455516779687 (37.7825826688577, -122.455516779687)
5619 28099 3 9 531 Divisadero St 1 1 1 2   04/21/2016 12:00:00 AM 3 3x3   6001632.2486 2110287.5913 37.77453935789789 -122.43781819841101 (37.7745393578979, -122.437818198411)
5728 97579 3 9 628 Divisadero St 3 1 1 1 4   3 3x3   6001646.5608 2110651.222 37.7755386104847 -122.437794739235 (37.7755386104847, -122.437794739235)
5735 28095 3 9 650 Divisadero St 2 1 1 1 4 12/06/2006 12:00:00 AM 3 3x3   6001636.0563 2110732.7869 37.775761969914896 -122.437836920035 (37.7757619699149, -122.437836920035)
5854 30037 3 9 2231 Franklin St 1 1 1 2   02/14/2008 12:00:00 AM 3 3x3   6005477.24721 2117649.17337 37.794970327277 -122.425041479277 (37.794970327277, -122.425041479277)
5871 97602 3 9 833 Divisadero St 1 1 1 1 4   3 3xe   6001492.376 2111306.2278 37.777328323069796 -122.438375037891 (37.7773283230698, -122.438375037891)
5874 97590 3 9 559 Divisadero St 1 1 1 1 4   3 3x3   6001615.3648 2110410.2466 37.774875178544995 -122.437885389718 (37.774875178545, -122.437885389718)
Powered by Datasette · Query took 2.391ms · Data source: data.sfgov.org