sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
28847 198338 2 51 474 Natoma St 4 1 1 1     2 Width 2ft   6010471.529619999 2112264.21742 37.7804653742171 -122.40738063611299 (37.7804653742171, -122.407380636113)
28936 49804 1 51 1112SSIPPI 18th St 1 1 1 1 1 06/11/2003 12:00:00 AM 5   Permit Number 46599 6014208.95643 2105755.12489 37.7628013312333 -122.39399522840799 (37.7628013312333, -122.393995228408)
29033 123711 2 51 437 Balboa St 1 1 1 1     4 Width 3ft   5994213.82065 2111401.8338099997 37.777174144242295 -122.46356067075199 (37.7771741442423, -122.463560670752)
29092 242342 2 51 50 Whitney St 1 1 1 1     11 Width 3ft   6004264.15883 2097942.68629 37.740792476382 -122.427834099074 (37.740792476382, -122.427834099074)
29107 86900 1 51 1515 Greenwich St 5 1 1 1   10/26/2007 12:00:00 AM 5 3x3 Permit Number 49845 6005565.12531 2119584.9629 37.8002904772924 -122.424875195545 (37.8002904772924, -122.424875195545)
29241 180442 2 51 599 University St 9 1 1 1     4 Width 4ft   6008511.7814 2091523.97842 37.723407462461296 -122.412693709355 (37.7234074624613, -122.412693709355)
29284 198256 2 51 718 Tennessee St 2 1 1 1     7 Width 4ft   6015417.87325 2105664.96075 37.762620874174104 -122.38980767650499 (37.7626208741741, -122.389807676505)
29317 217810 2 51 198 Lee Ave 1 2 1 1     2 Width 3ft   5996576.41484 2091837.9853700001 37.7235925393546 -122.453974506819 (37.7235925393546, -122.453974506819)
29488 219440 2 51 142 Joost Ave 1 1 1 1     5 Width 3ft   6001119.093859999 2094963.2287700002 37.732433161058395 -122.438495108681 (37.7324331610584, -122.438495108681)
29520 32018 1 51 729 Filbert St 1 1 1 1   07/24/1995 12:00:00 AM 11   Permit Number 35411 6009321.52864 2119764.77649 37.800995657295395 -122.41188922351101 (37.8009956572954, -122.411889223511)
29751 219429 3 51 900x Kirkham St 1 11 1 2     1 Width 4ft   5992085.46562 2105232.9931400004 37.7601132972171 -122.47047387378099 (37.7601132972171, -122.470473873781)
29811 180436 2 51 599 University St 2 1 1 1     1 Width 3ft   6008572.212 2091322.68535 37.722858145766004 -122.412470589353 (37.722858145766, -122.412470589353)
29877 102353 1 51 662 12th Ave 1 1 1 1 1 07/10/2009 12:00:00 AM 2 3x3 Permit Number 52560 5992263.7285400005 2110921.14049 37.775741736970204 -122.470271582701 (37.7757417369702, -122.470271582701)
30123 120689 2 51 598 22nd Ave 1 1 1 1     1 Width 3ft   5989116.38632 2111294.87868 37.7765854515948 -122.48118627511299 (37.7765854515948, -122.481186275113)
30440 123815 2 51 1951 Anza St 2 1 1 1     3 Width 3ft   5992581.39914 2112024.84953 37.7787905839512 -122.469253041386 (37.7787905839512, -122.469253041386)
30456 198402 2 51 85 Harriet St 2 1 1 1     1 Width 2ft   6010657.10977 2111573.60472 37.778579498568604 -122.406689940589 (37.7785794985686, -122.406689940589)
30575 42240 1 51 532 Natoma St 1 1 1 1 1 06/23/2000 12:00:00 AM 2   Permit Number 42489 6010157.096530001 2111965.88499 37.7796286197948 -122.408447363381 (37.7796286197948, -122.408447363381)
30659 51400 1 51 421 Tehama St 1 1 1 1   06/02/2008 12:00:00 AM 3 3c3 Permit Number 50561 6011183.79367 2112305.04226 37.7806173092731 -122.404919441686 (37.7806173092731, -122.404919441686)
30819 123714 2 51 339 Balboa St 1 1 1 1     4 Width 3ft   5994520.39053 2111414.8777 37.7772276185203 -122.462501102485 (37.7772276185203, -122.462501102485)
30849 198285 2 51 500 Amador St 5 2 1 1     1 Width 8ft   6017793.32679 2099592.23757 37.7460778765941 -122.381169499371 (37.7460778765941, -122.381169499371)
30973 198274 2 51 1236 Rhode Island St 1 1 1 1     4 Width 3ft   6011932.48905 2102621.16084 37.7540693755115 -122.401648489597 (37.7540693755115, -122.401648489597)
31042 198387 2 51 120 Minna St 6 1 1 1     1 Width 2ft   6011311.4774 2113337.57021 37.7834595257768 -122.404550424668 (37.7834595257768, -122.404550424668)
31127 92816 1 51 410 Locust St 1 1 1 1   11/12/2009 12:00:00 AM 3 3x3 Permit Number 53025 5997688.97866 2114964.50163 37.787155913848 -122.451796128513 (37.787155913848, -122.451796128513)
31158 198377 2 51 413 Minna St 16 1 1 1     4 Width 3ft   6011450.02335 2113431.79039 37.7837259742093 -122.404077740098 (37.7837259742093, -122.404077740098)
31159 242866 2 51 98 McCoppin St 5 4 1 1     1 Width 3ft   6006095.439119999 2109158.70233 37.7716924795429 -122.422298906788 (37.7716924795429, -122.422298906788)
31207 198409 2 51 50 Washburn St 2 1 1 1     8 Width 2ft   6008437.7646 2110373.29523 37.7751593120891 -122.41428258206801 (37.7751593120891, -122.414282582068)
31240 53102 1 51 429@ GEARY BL 06th Ave 1 1 1 1   10/30/2006 12:00:00 AM 4   Permit Number 49065 5994018.99484 2112572.39265 37.7803769568855 -122.46431963578999 (37.7803769568855, -122.46431963579)
31345 54056 1 51 839 35th Ave 1 1 1 1   04/21/1972 12:00:00 AM 12   Permit Number 9778 5985079.18018 2110144.91058 37.7731924364746 -122.495067118327 (37.7731924364746, -122.495067118327)
31564 242341 2 51 1867 Church St 1 1 1 1     9 Width 3ft   6004609.18081 2097837.81117 37.7405240251544 -122.426633675907 (37.7405240251544, -122.426633675907)
31590 198270 2 51 101 Pennsylvania Ave 9 7 1 1     1     6014327.719219999 2106393.16587 37.764559852075 -122.39362912521099 (37.764559852075, -122.393629125211)
31735 198284 2 51 500 Amador St 4 2 1 1     1 Width 8ft   6017813.21777 2099593.44192 37.74608228148 -122.381100801954 (37.74608228148, -122.381100801954)
31927 117672 2 51 7751 Geary Blvd 1 1 1 1     7 Width 2ft   5982922.15587 2112497.69809 37.77952599164671 -122.502702614984 (37.7795259916467, -122.502702614984)
32025 242890 2 51 2230 Bryant St 1 1 1 1     5 Width 3ft   6009606.26166 2104418.84355 37.7588753255595 -122.40982006693999 (37.7588753255595, -122.40982006694)
32167 198365 2 51 413 Minna St 4 1 1 1     5 Width 3ft   6011243.08951 2113235.2529700003 37.7831747644438 -122.404779815658 (37.7831747644438, -122.404779815658)
32179 180406 2 51 23 Gorham St 4 1 1 1     7 Width 2ft   6002284.81507 2094188.8168099998 37.7303730435723 -122.43440959293999 (37.7303730435723, -122.43440959294)
32498 136953 2 51 685 North Point St 4 1 1 1     7 Width 4ft   6007628.69919 2121609.81563 37.8059665519739 -122.41787801227 (37.8059665519739, -122.41787801227)
32574 52874 1 51 3476@ LAUREL Clay St 1 1 1 1   07/28/2006 12:00:00 AM 4   Permit Number 48886 5998188.79133 2115538.04458 37.7887593241423 -122.45010824850701 (37.7887593241423, -122.450108248507)
32694 104489 2 51 101X Arkansas St 2 1 1 1     1 3x3   6012893.40207 2106545.4722700003 37.7648982471715 -122.398600762736 (37.7648982471715, -122.398600762736)
32706 120106 2 51 2651 Cabrillo St 1 1 1 1     6 Width 3ft   5987317.09594 2110472.8163099997 37.7742235329464 -122.487350063639 (37.7742235329464, -122.487350063639)
32720 198344 2 51 451 Tehama St 1 1 1 1     3 Width 2ft   6010981.61371 2112109.48263 37.780069044799106 -122.40560510460101 (37.7800690447991, -122.405605104601)
33164 44473 1 51 258 Harvard St 1 1 1 1 1 03/26/2001 12:00:00 AM 6   Permit Number 43787 6006246.79793 2092607.35071 37.7262547826049 -122.420600221446 (37.7262547826049, -122.420600221446)
33462 68846 1 51 731 44th Ave 1 1 1 1   12/09/1993 12:00:00 AM 9   Permit Number 32807 5982263.55129 2110779.79011 37.774770393997706 -122.50485363813101 (37.7747703939977, -122.504853638131)
33652 180465 2 51 599 University St 33 1 1 1     8 Width 3ft   6008194.47669 2092552.7848 37.7262145316512 -122.413863317257 (37.7262145316512, -122.413863317257)
33703 117914 2 51 839 41st Ave 1 1 1 1     1 Width 3ft   5983220.24264 2110063.17362 37.7728590079713 -122.501491276363 (37.7728590079713, -122.501491276363)
33722 242337 2 51 157 Chattanooga St 1 1 1 1     5 Width 3ft   6004758.7797 2102744.04826 37.754003877891606 -122.42646567447599 (37.7540038778916, -122.426465674476)
33820 198396 2 51 16 Moss St 1 1 1 1     3 Width 3ft   6010197.36501 2111335.28961 37.7778994078643 -122.408263568012 (37.7778994078643, -122.408263568012)
33823 136938 2 51 1277 Clay St 1 1 1 1     3 Width 3ft   6008610.97542 2116946.31505 37.7932169703383 -122.41414853544201 (37.7932169703383, -122.414148535442)
33869 198258 2 51 401 16th St 2 1 1 1     1 Width 5ft   6015275.05109 2107162.53945 37.766724978901 -122.390406293135 (37.766724978901, -122.390406293135)
33902 201660 2 51 130 Dore St 2 4 1 1     3 Width 2ft   6009127.89234 2109540.91695 37.7729125385177 -122.411836435997 (37.7729125385177, -122.411836435997)
34216 32016 1 51 2920 Anza St 1 1 1 1 1 12/03/2002 12:00:00 AM 7   Permit Number 46155 5989557.12792 2111970.2291 37.7784653891782 -122.479711067145 (37.7784653891782, -122.479711067145)
34285 242910 2 51 360 Lily St 2 1 1 1     3 Width 2ft   6004800.5697 2110038.5843599997 37.774035296231105 -122.426840616201 (37.7740352962311, -122.426840616201)
34306 44480 1 51 295 Harvard St 5 1 1 1 1 03/26/2001 12:00:00 AM     Permit Number 43790 6006326.11018523 2092518.45956429 37.72601517641179 -122.420319736223 (37.7260151764118, -122.420319736223)
34908 52183 1 51 2230 Revere Ave 1 1 1 1 1 11/01/2005 12:00:00 AM 5   Permit Number 48373 6011742.35118 2096927.06221 37.738423995777104 -122.401905791943 (37.7384239957771, -122.401905791943)
35027 242906 2 51 2641 20th St 1 1 1 1     2 Width 3ft   6010204.149619999 2104543.2646 37.759250446279005 -122.407761055636 (37.759250446279, -122.407761055636)
35277 136947 2 51 915 Front St 1 1 1 1     5 Width 4ft   6012726.66985 2119026.8860400002 37.799160033972 -122.400054056345 (37.799160033972, -122.400054056345)
35317 123509 2 51 2636 Fulton St 3 2 1 1     3 Width 8ft   5995163.8038800005 2110297.4884900004 37.77419659482779 -122.46019437077899 (37.7741965948278, -122.460194370779)
35409 78535 2 51 62 Colby St 2 1 1 1 1 09/16/2000 12:00:00 AM 6     6007981.72204 2093794.7148099998 37.7296126541786 -122.41468665108 (37.7296126541786, -122.41468665108)
35682 198337 2 51 474 Natoma St 3 1 1 1     2 Width 2ft   6010500.52756 2112291.4654599996 37.7805418139019 -122.407282239501 (37.7805418139019, -122.407282239501)
35758 242888 2 51 1100 Guerrero St 1 1 1 1     1 Width 3ft   6005717.8738400005 2102519.39452 37.753441201753205 -122.423132926343 (37.7534412017532, -122.423132926343)
35858 246494 2 51 365 Duncan St 1 4 1 1     5 Width 4ft   6004182.0093 2099825.58993 37.745957849487795 -122.428252301803 (37.7459578494878, -122.428252301803)
35907 242901 2 51 3666 20th St 1 1 1 1     1 Width 3ft   6005862.21716 2104347.95143 37.758470138701895 -122.422763695285 (37.7584701387019, -122.422763695285)
35932 52449 1 51 447 11th Ave 1 1 1 1 1 12/27/2005 12:00:00 AM 5 3x3 Permit Number 48562 5992476.75463 2112405.61073 37.779830003091504 -122.469642770977 (37.7798300030915, -122.469642770977)
36031 103531 1 51 130 South Hill Blvd 1 1 1 1   02/07/2014 12:00:00 AM 1   Permit Number 770957 6003099.91342 2086880.6888299999 37.7103527759382 -122.43107027978901 (37.7103527759382, -122.431070279789)
36175 52474 1 51 576 Funston Ave 2 1 1 1 1 12/27/2005 12:00:00 AM 2 3x3 Permit Number 48585 5991932.93207 2111539.52731 37.777420528381796 -122.471460949443 (37.7774205283818, -122.471460949443)
36218 31084 1 51 1397 Minna St 2 1 1 1 1 03/21/1995 12:00:00 AM 9   Permit Number 34820 6006995.97256 2107440.57968 37.7670256771058 -122.419062011995 (37.7670256771058, -122.419062011995)
36650 242863 2 51 98 McCoppin St 1 4 1 1     1 Width 3ft   6006168.47171 2109163.73568 37.7717104192431 -122.422046639762 (37.7717104192431, -122.422046639762)
36728 136945 2 51 805 Lombard St 2 1 1 1     3 Width 3ft   6008467.13732 2120338.97067 37.802524280839705 -122.414886453447 (37.8025242808397, -122.414886453447)
36732 54017 1 51 848 35th Ave 1 1 1 1   12/06/2007 12:00:00 AM 7 3x3 Permit Number 49959 5985128.25093 2110100.49047 37.7730733441171 -122.494894102815 (37.7730733441171, -122.494894102815)
36902 136926 2 51 3835 Scott St 2 1 1 1     11 Width 5ft   6000573.99959 2121502.15962 37.805271409309 -122.442284116143 (37.805271409309, -122.442284116143)
36919 43183 1 51 350 University St 1 1 1 1 1 07/11/2000 12:00:00 AM 6   Permit Number 42986 6008206.3757 2092356.2981200002 37.7256756893785 -122.41380829041401 (37.7256756893785, -122.413808290414)
36920 242908 2 51 320 Lily St 2 1 1 1     4 Width 2ft   6004832.66793 2110043.51339 37.7740506449575 -122.426729933953 (37.7740506449575, -122.426729933953)
37242 87382 1 51 75 Moss St 4 1 1 1   04/24/2008 12:00:00 AM 4 3x3 Permit Number 50362 6010348.37894 2111212.00043 37.777569339594706 -122.407732459893 (37.7775693395947, -122.407732459893)
37378 198292 2 51 500 Amador St 12 2 1 1     1 Width 8ft   6017651.2465699995 2099584.75723 37.7460494930826 -122.381660279195 (37.7460494930826, -122.381660279195)
37392 45242 1 51 604 University St 1 1 1 1 1 06/12/2001 12:00:00 AM     Permit Number 44093 6008555.70872799 2091212.30248413 37.7225541315384 -122.41251983895201 (37.7225541315384, -122.412519838952)
37463 101234 1 51 251 Balboa St 2 1 1 1     2 3x3   5994788.53914 2111424.28345 37.7772688824616 -122.46157417945801 (37.7772688824616, -122.461574179458)
37494 70335 2 51 320 Silliman St 1 1 1 1 1 04/30/1994 12:00:00 AM 6     6009780.67381 2094049.10859 37.7304120750579 -122.408485397509 (37.7304120750579, -122.408485397509)
37498 198311 2 51 75 Lansing St 1 1 1 1     2 Width 3ft   6014300.67476 2114126.83927 37.7857932808859 -122.394264166169 (37.7857932808859, -122.394264166169)
37559 35018 1 51 15 Alhambra St 1 1 1 1   12/29/1997 12:00:00 AM 10   Permit Number 38593 6001898.27273 2120571.24867 37.8027907607435 -122.437634600462 (37.8027907607435, -122.437634600462)
37968 136932 2 51 3825 Scott St 5 1 1 1     11 Width 5ft   6000587.38423 2121403.46977 37.8050011962985 -122.442230708079 (37.8050011962985, -122.442230708079)
38368 124531 2 51 821 Balboa St 2 1 1 1     4 Width 3ft   5993023.60492 2111359.71361 37.776989843561 -122.46767490536301 (37.776989843561, -122.467674905363)
38435 136931 2 51 3825 Scott St 4 1 1 1     8 Width 5ft   6000586.31642 2121417.2428200003 37.805038952541295 -122.442235392672 (37.8050389525413, -122.442235392672)
38497 180409 2 51 141 Rousseau St 2 9 1 1     1     6003595.96524 2094719.6833400002 37.7319050215902 -122.429914617678 (37.7319050215902, -122.429914617678)
38531 86963 1 51 1501 Greenwich St 2 1 1 1   11/26/2007 12:00:00 AM 3 3x3 Permit Number 49931 6005615.529680001 2119592.0276 37.8003127220137 -122.42470127923401 (37.8003127220137, -122.424701279234)
38555 198390 2 51 120 Minna St 9 1 1 1     2 Width 2ft   6011047.1046400005 2113083.17782 37.7827462455888 -122.405447134184 (37.7827462455888, -122.405447134184)
38574 219441 2 51 147 Stillings Ave 1 9 1 1     2 Width 8ft   5999786.27103 2095740.5208700001 37.734491517651 -122.443158781469 (37.734491517651, -122.443158781469)
38608 180407 2 51 314 Cayuga Ave 1 9 1 1     8 Width 3ft   6002242.22225 2094108.3589599999 37.7301497068323 -122.434551091376 (37.7301497068323, -122.434551091376)
38671 180422 3 51 1132x Alemany Blvd 10 11 1 2     1 Width 3ft   6003342.53075 2094283.93013 37.7306941860739 -122.43075970881901 (37.7306941860739, -122.430759708819)
38673 242350 2 51 70 McCoppin St 4 1 1 1     1 Width 4ft   6006095.21609 2109159.69147 37.771695182903706 -122.42229974855302 (37.7716951829037, -122.422299748553)
38795 198287 2 51 500 Amador St 7 2 1 1     1 Width 8ft   6017753.37339 2099590.18904 37.7460700461913 -122.38130751204399 (37.7460700461913, -122.381307512044)
38853 70336 2 51 324 Silliman St 1 1 1 1 1 04/30/1994 12:00:00 AM 8     6009735.9866 2094035.87413 37.7303732333298 -122.408638954927 (37.7303732333298, -122.408638954927)
38905 65281 1 51 443 Tehama St 1 1 1 1 1 08/19/1989 12:00:00 AM 3   Permit Number 28088 6011045.68858 2112172.30893 37.7802451338574 -122.405387865261 (37.7802451338574, -122.405387865261)
38922 180401 2 51 450 Munich St 1 1 1 1     1 Width 3ft   6003847.76406 2089839.62189 37.7185197127976 -122.428696343867 (37.7185197127976, -122.428696343867)
38984 82050 1 51 116 Cherry St 2 1 1 1   06/04/2008 12:00:00 AM 6 3x3 Permit Number 50668 5996119.951719999 2115777.79007 37.78929899740071 -122.457283443584 (37.7892989974007, -122.457283443584)
39275 198334 2 51 432 Natoma St 1 1 1 1     1 Width 3ft   6010764.31285 2112543.17724 37.7812477151384 -122.406387417652 (37.7812477151384, -122.406387417652)
39379 48916 1 51 77 Connecticut St 4 1 1 1   11/22/2002 12:00:00 AM 5   Permit Number 46108 6013166.41174 2106720.77544 37.765394797053496 -122.39766878180299 (37.7653947970535, -122.397668781803)
39438 180429 2 51 220 Ocean Ave 2 1 1 1     9 Width 3ft   6000152.41454 2091672.2540900002 37.723341869512204 -122.441601052259 (37.7233418695122, -122.441601052259)
39498 198275 2 51 1199 Kansas St 1 1 1 1     6 Width 1ft   6011697.22277 2102839.72016 37.754656360309994 -122.40247746938 (37.75465636031, -122.40247746938)
39506 198280 2 51 951 Phelps St 2 4 1 1     1 Width 3ft   6014735.9327300005 2097232.0415 37.739428022289204 -122.39157667443001 (37.7394280222892, -122.39157667443)
39512 106411 1 51 2159 Chestnut St 2 1 1 1   04/28/2014 12:00:00 AM 1   Permit Number 772621 6001561.17582 2119720.78456 37.8004364390406 -122.438740147849 (37.8004364390406, -122.438740147849)
39535 136939 2 51 1149 Taylor St 1 1 1 1     4 Width 4ft   6008985.04879 2116923.16762 37.7931744171228 -122.412852575501 (37.7931744171228, -122.412852575501)
39624 180440 2 51 599 University St 6 1 1 1     4 Width 4ft   6008537.64455 2091440.44703 37.72317955448779 -122.41259840282 (37.7231795544878, -122.41259840282)
Powered by Datasette · Query took 17.647ms · Data source: data.sfgov.org