sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
185766 228589 2 11 2820 17th St 3 1 1 1     11 Width 3ft   6008794.575180001 2106388.6841599997 37.764238535116206 -122.41276652837401 (37.7642385351162, -122.412766528374)
185723 202769 2 11 77 Long Bridge St 5 1 1 1     4 Width 5ft   6014575.89833 2109172.63741 37.7722054555392 -122.392965215098 (37.7722054555392, -122.392965215098)
185711 228784 2 11 20 Hickory St 3 1 1 1     4 Width 4ft   6006829.74541 2110663.1076599997 37.77586460991171 -122.41986566058998 (37.7758646099117, -122.41986566059)
185672 229070 2 11 1425 Cole St 1 1 1 1     15 Width 4ft   5998267.3386 2105513.86084 37.7612399939635 -122.44911405249701 (37.7612399939635, -122.449114052497)
185664 129908 2 11 65 Cervantes Blvd 2 1 1 1     9 Width 4ft   6001694.14605 2120844.10453 37.803528342422794 -122.438360541313 (37.8035283424228, -122.438360541313)
185652 102357 1 11 3551 Scott St 1 1 1 1 1 01/16/2013 12:00:00 AM 3 3x3 Permit Number 769877 6000702.4264400005 2120580.06982 37.802746916103295 -122.441773461287 (37.8027469161033, -122.441773461287)
185643 130333 2 11 150 Lombard St 8 1 1 1     12 Width 3ft   6011625.98867 2120823.31457 37.804031159681394 -122.40398929806601 (37.8040311596814, -122.403989298066)
185642 130017 2 11 488 Ellis St 4 1 1 1     8 Width 4ft   6008520.4701 2113862.5861299997 37.7847447172366 -122.414243411208 (37.7847447172366, -122.414243411208)
185635 130078 2 11 601 Van Ness Ave 8 1 1 1     8 Width 4ft   6006636.458330001 2112607.58351 37.781192779173104 -122.42067235963499 (37.7811927791731, -122.420672359635)
185631 228598 2 11 2130 Harrison St 1 1 1 1     1 Width 3ft   6008719.47717 2105938.46018 37.7629981083047 -122.412994436344 (37.7629981083047, -122.412994436344)
185615 229016 2 11 2900 20th St 2 1 1 1     14 Width 4ft   6009519.4903 2104549.01087 37.7592278723746 -122.410129353684 (37.7592278723746, -122.410129353684)
185600 130066 2 11 820 Gough St 1 1 1 1     7 Width 4ft   6005746.45036 2112612.6258 37.7811564231596 -122.42375170848699 (37.7811564231596, -122.423751708487)
185588 208405 2 11 17 Santa Monica Way 1 2 1 1     5 Width 3ft   5993430.6013400005 2097468.6651 37.73887212166029 -122.46525774297301 (37.7388721216603, -122.465257742973)
185536 228753 2 11 36 States St 1 9 1 1     5 Width 3ft   6002041.28039 2106249.9304299997 37.763476187904296 -122.43611428487199 (37.7634761879043, -122.436114284872)
185517 200475 2 11 1495 Tennessee St 7 1 1 1     8 Width 3ft   6015666.49707 2102252.1345 37.7532637646194 -122.388709514333 (37.7532637646194, -122.388709514333)
185487 228626 2 11 3926 18th St 1 1 1 1     13 Width 3ft   6003423.4893 2105384.37737 37.76117801805871 -122.431271881716 (37.7611780180587, -122.431271881716)
185425 202424 2 11 120 Brannan St 13 1 1 1     12 Width 3ft   6015792.05409 2113571.87018 37.784352246798 -122.389065605418 (37.784352246798, -122.389065605418)
185400 201155 2 11 3450 03rd St 8 4 1 1     11 Width 3ft   6016026.02144 2099329.8922 37.745259814586795 -122.38726237027599 (37.7452598145868, -122.387262370276)
185377 202402 2 11 427 Beale St 3 1 1 1     13 Width 4ft   6015305.1908599995 2114649.65643 37.787284602342 -122.390825344821 (37.787284602342, -122.390825344821)
185368 202374 2 11 299 Spear St 10 1 1 1     6 Width 5ft   6015354.42559 2115632.91412 37.7899871343417 -122.39072374032 (37.7899871343417, -122.39072374032)
185335 202409 2 11 300 Beale St 2 1 1 1     8 Width 3ft   6014816.592730001 2115071.66562 37.7884162210836 -122.392545335093 (37.7884162210836, -122.392545335093)
185295 192721 2 11 1200 Ingalls St 3 1 1 1     3 Width 3ft   6017930.52005 2093957.2427700001 37.7306128747628 -122.380303548475 (37.7306128747628, -122.380303548475)
185292 75924 2 11 500 Hyde St 4 1 1 1 1 05/29/1982 12:00:00 AM 17     6007948.10688 2114213.26854 37.785675439112396 -122.416248450599 (37.7856754391124, -122.416248450599)
185219 228715 2 11 37 Noe St 1 1 1 1     15 Width 3ft   6002859.5798 2108072.9095799997 37.7685281007225 -122.433414330326 (37.7685281007225, -122.433414330326)
185107 192513 2 11 560 Mission Bay Blvd North 18 1 1 1     4 Width 5ft   6014659.7547 2108718.7787900004 37.770963918076404 -122.39264339178301 (37.7709639180764, -122.392643391783)
185098 129916 2 11 512 Webster St 1 1 1 1     9 Width 3ft   6004084.72879 2110562.0124 37.7754320009199 -122.429354165577 (37.7754320009199, -122.429354165577)
185084 202555 2 11 1 Bluxome St 2 1 1 1     11 Width 3ft   6013779.77553 2111120.49842 37.777509588621 -122.39585560737301 (37.777509588621, -122.395855607373)
185049 192683 2 11 1 Westbrook Ct 8 1 1 1     13 Width 3ft   6017532.94915 2095576.52883 37.7350371705259 -122.381790607154 (37.7350371705259, -122.381790607154)
185019 201059 2 11 501 Illinois St 2 1 1 1     7 Width 3ft   6015989.38827 2106628.51362 37.765298259327295 -122.38789823233499 (37.7652982593273, -122.387898232335)
185003 202520 2 11 41 Lansing St 2 1 1 1     1 Width 3ft   6014454.63005 2114268.41989 37.78619058516529 -122.39374143341699 (37.7861905851653, -122.393741433417)
184925 249371 2 11 651 Jones St 3 4 1 1     7 Width 3ft   6008791.00522 2114822.15821 37.7873946631776 -122.41337532982 (37.7873946631776, -122.41337532982)
184918 228025 2 11 621 Valencia St 4 1 1 1     10 Width 3ft   6006233.32164 2106033.04315 37.7631179375756 -122.42159992849399 (37.7631179375756, -122.421599928494)
184885 191612 2 11 202 Jessie St 3 1 1 1     2 Width 3ft   6011988.75206 2114601.1815400003 37.7869669339158 -122.40229617864401 (37.7869669339158, -122.402296178644)
184829 129866 2 11 2150 North Point St 7 1 1 1     7 Width 4ft   6000402.94592 2120648.58524 37.8029179725475 -122.442814735917 (37.8029179725475, -122.442814735917)
184810 202716 2 11 415 Bryant St 2 1 1 1     9 Width 3ft   6014375.68893 2113000.2537599998 37.7827041042563 -122.393925745878 (37.7827041042563, -122.393925745878)
184778 201020 2 11 2415 03rd St 3 1 1 1     6 Width 3ft   6015834.180869999 2104378.6233200002 37.75911194438579 -122.38827802503599 (37.7591119443858, -122.388278025036)
184758 228983 2 11 1300 San Jose Ave 39 9 1 1     6     6003399.166619999 2095595.2622599998 37.734298015935295 -122.430657448703 (37.7342980159353, -122.430657448703)
184754 75978 2 11 500 Hyde St 2 1 1 1 1 05/29/1982 12:00:00 AM 16     6007956.14824 2114165.5597099997 37.7855448944115 -122.416217249547 (37.7855448944115, -122.416217249547)
184747 192656 2 11 299 Cashmere St 10 1 1 1     9 Width 3ft   6016666.45643 2095945.35214 37.736002000097606 -122.384812095401 (37.7360020000976, -122.384812095401)
184744 208345 2 11 3594 19th Ave 1 2 1 1     2 Width 3ft   5990578.14128 2092637.2329799999 37.7254413233411 -122.474767578959 (37.7254413233411, -122.474767578959)
184719 228686 2 11 72 Hattie St 1 1 1 1     15 Width 3ft   6000606.2014 2105304.5578400004 37.760798791952205 -122.44100992426701 (37.7607987919522, -122.441009924267)
184694 246832 2 11 200 Baker St 4 4 1 1     12 Width 3ft   6000792.448369999 2109807.86593 37.7731743635249 -122.44068880603999 (37.7731743635249, -122.44068880604)
184680 208194 2 11 338 Ortega St 1 1 1 1     26 Width 4ft   5992905.17714 2102566.7418400003 37.7528398269164 -122.46744502009399 (37.7528398269164, -122.467445020094)
184677 201102 2 11 199 Utah St 4 1 1 1     9 Width 4ft   6010597.07336 2107530.66905 37.7674751717804 -122.406612651066 (37.7674751717804, -122.406612651066)
184657 130148 2 11 399 Grove St 3 1 1 1     5 Width 4ft   6005992.302080001 2111377.41632 37.7777787143452 -122.422813372063 (37.7777787143452, -122.422813372063)
184562 228577 2 11 3132 21st St 1 1 1 1     13 Width 3ft   6007388.02772 2103845.9473099997 37.7571777211942 -122.417451170662 (37.7571777211942, -122.417451170662)
184528 228758 2 11 46 States St 1 9 1 1     7 Width 3ft   6001976.01738 2106245.24414 37.7634596124877 -122.43633967294 (37.7634596124877, -122.43633967294)
184526 129991 2 11 1020 Gough St 1 1 1 1     7 Width 4ft   6005653.153940001 2113299.68835 37.7830376609932 -122.42412334433 (37.7830376609932, -122.42412334433)
184509 130300 2 11 815 Battery St 8 1 1 1     3 Width 4ft   6012386.58963 2118971.9326 37.798990178098 -122.401226993538 (37.798990178098, -122.401226993538)
184494 208460 2 11 545 Teresita Blvd 1 9 1 1     15 Width 3ft   5998994.59253 2097295.1297 37.738714930956704 -122.446007644855 (37.7387149309567, -122.446007644855)
184417 33857 1 11 757 Pennsylvania Ave 1 1 1 1 1 12/25/2005 12:00:00 AM 13   Permit Number 37855 6014476.109730001 2103508.37921 37.7566470977886 -122.39291403375499 (37.7566470977886, -122.392914033755)
184413 191611 2 11 75 01st St 2 1 1 1     6 Width 3ft   6013242.23758 2115774.13253 37.790257474145 -122.398041690185 (37.790257474145, -122.398041690185)
184374 92892 2 11 642 Harrison St 2 1 1 1     7 3x3   6013735.378 2113344.3843 37.7836134015686 -122.396165091043 (37.7836134015686, -122.396165091043)
184349 130405 2 11 502 Clay St 3 1 1 1     6 Width 2ft   6012102.526000001 2117469.9807599997 37.7948503271223 -122.40210430559401 (37.7948503271223, -122.402104305594)
184346 202491 2 11 87 Townsend St 5 1 1 1     9 Width 4ft   6015462.64565 2112286.54201 37.780804760374295 -122.39011542988001 (37.7808047603743, -122.39011542988)
184328 228610 2 11 2001 Harrison St 2 1 1 1     9 Width 3ft   6008738.30789 2106670.03017 37.7650078880392 -122.412981035564 (37.7650078880392, -122.412981035564)
184284 130259 2 11 501 Jefferson St 2 1 1 1     3 Width 4ft   6007382.90307 2122272.11478 37.8077712206334 -122.41877563011101 (37.8077712206334, -122.418775630111)
184191 208325 2 11 230 Farallones St 1 1 1 1     11 Width 3ft   5994700.197380001 2088418.89135 37.7140967660267 -122.460212618242 (37.7140967660267, -122.460212618242)
184161 201131 2 11 1301 Cesar Chavez St 3 4 1 1     6 Width 3ft   6014896.91206 2101063.92865 37.7499585204909 -122.39128786525299 (37.7499585204909, -122.391287865253)
184145 228169 2 11 712 Eugenia Ave 2 1 1 1     13 Width 3ft   6007884.413380001 2097705.90914 37.7403464729105 -122.41529982501999 (37.7403464729105, -122.41529982502)
184123 92893 2 11 642 Harrison St 3 1 1 1     13 3x3   6013727.291259999 2113337.6212400002 37.7835943818045 -122.39619259412599 (37.7835943818045, -122.396192594126)
184104 33333 1 11 3042 Octavia St 1 1 1 1 1 04/13/2006 12:00:00 AM 8   Permit Number 48741 6004278.25254 2119648.85188 37.8003931295033 -122.429332840858 (37.8003931295033, -122.429332840858)
184078 228772 2 11 201 Fell St 1 1 1 1     9 Width 4ft   6006402.31382 2110745.78275 37.7760675266195 -122.42135013101002 (37.7760675266195, -122.42135013101)
184075 208448 2 11 79 Dorado Ter 1 1 1 1     22 Width 3ft   5994592.569569999 2093111.8186299999 37.726976229566205 -122.46092454135 (37.7269762295662, -122.46092454135)
184072 229166 2 11 1369 Valencia St 3 1 1 1     6 Width 3ft   6006475.81783 2101605.35927 37.7509742139056 -122.42044691578998 (37.7509742139056, -122.42044691579)
184061 228861 2 11 280 Valencia St 2 4 1 1     6 Width 3ft   6006057.3965 2107996.75615 37.76849990698 -122.422347927012 (37.76849990698, -122.422347927012)
184034 228773 2 11 201 Fell St 2 1 1 1     16 Width 4ft   6006414.99756 2110745.52232 37.77606752663979 -122.421306236009 (37.7760675266398, -122.421306236009)
184030 130313 2 11 300 Bay St 2 1 1 1     5 Width 3ft   6009225.50566 2121536.68624 37.8058554919917 -122.412346817477 (37.8058554919917, -122.412346817477)
183972 130277 2 11 500 Beach St 3 1 1 1     9 Width 3ft   6007637.996780001 2122009.8332599998 37.807065421886 -122.41787420993099 (37.807065421886, -122.417874209931)
183964 228178 2 11 131 Shotwell St 2 1 1 1     8 Width 3ft   6007747.837590001 2107196.4501099996 37.7663976652576 -122.416444126014 (37.7663976652576, -122.416444126014)
183938 228569 2 11 508 Valencia St 1 1 1 1     5 Width 3ft   6006139.40955 2106596.9487 37.7646609934284 -122.421964799655 (37.7646609934284, -122.421964799655)
183919 228677 2 11 190 Storrie St 13 7 1 1     15 Width 3ft   6000787.94516 2105321.30732 37.7608551317704 -122.44038255632 (37.7608551317704, -122.44038255632)
183915 208239 2 11 40 Santa Monica Way 3 2 1 1     4 Width 6ft   5993602.68671 2097407.79413 37.738714907574604 -122.464658337632 (37.7387149075746, -122.464658337632)
183888 110750 1 11 1155 Howard St 1 1 1 1 1   7   50109 6009522.08219 2110985.7839099998 37.7769019113319 -122.41057493088199 (37.7769019113319, -122.410574930882)
183879 208200 2 11 141 San Benito Way 2 2 1 1     3 Width 6ft   5992880.92249 2095766.2437900002 37.7341659846737 -122.467034523631 (37.7341659846737, -122.467034523631)
183867 111189 1 11 8 10th St 8 1 1 1     2 3x6   6007707.06136 2110648.86423 37.7758748864569 -122.416829782278 (37.7758748864569, -122.416829782278)
183806 130201 2 11 1200 Mason St 4 1 1 1     12 Width 3ft   6009429.74314 2117502.72379 37.7947906877019 -122.411354860739 (37.7947906877019, -122.411354860739)
183802 201123 2 11 3305 03rd St 1 4 1 1     6 Width 3ft   6016087.07184 2099842.99163 37.7466720604868 -122.38708704742399 (37.7466720604868, -122.387087047424)
183746 202382 2 11 304 Spear St 7 1 1 1     1 Width 3ft   6015836.791619999 2115035.51841 37.7883735725194 -122.38901305353201 (37.7883735725194, -122.389013053532)
183615 130178 2 11 100 Fell St 7 1 1 1     4 Width 4ft   6006688.806419999 2110839.1222900003 37.7763399627555 -122.420365701616 (37.7763399627555, -122.420365701616)
183589 228878 2 11 317 Buchanan St 2 4 1 1     10 Width 4ft   6004644.5004900005 2109700.89583 37.7730992602639 -122.427356425982 (37.7730992602639, -122.427356425982)
183457 200425 2 11 2833 03rd St 2 1 1 1     5 Width 3ft   6015964.97782 2102366.8244 37.7535952169477 -122.387685298953 (37.7535952169477, -122.387685298953)
183365 129966 2 11 1005 Larkin St 2 1 1 1     9 Width 4ft   6007337.22214 2114824.39315 37.7873190688613 -122.418405289284 (37.7873190688613, -122.418405289284)
183338 35034 1 11 403 Main St 5 1 1 1   01/05/1998 12:00:00 AM 13   Permit Number 38603 6015612.4311 2114850.7115599997 37.7878536960372 -122.38977639806801 (37.7878536960372, -122.389776398068)
183322 208353 2 11 5000 19th Ave 5 2 1 1     9 Width 3ft   5990626.636469999 2093347.4472599998 37.727394203873 -122.474651748098 (37.727394203873, -122.474651748098)
183283 228150 2 11 298 Coleridge St 1 1 1 1     8 Width 3ft   6006255.81001 2098299.6746900002 37.74188515358411 -122.420973046186 (37.7418851535841, -122.420973046186)
183198 129895 2 11 400 Cherry St 3 1 1 1     13 Width 3ft   5996272.40169 2114646.25643 37.786200864412706 -122.456674122309 (37.7862008644127, -122.456674122309)
183169 130229 2 11 1541 Vallejo St 1 1 1 1     8 Width 3ft   6006183.93008 2118283.97946 37.7967532386312 -122.422641382112 (37.7967532386312, -122.422641382112)
183139 123778 2 11 1099 Cabrillo St 1 1 1 1     11 Width 3ft   5992301.31875 2110654.6770900004 37.775012273795 -122.470122142574 (37.775012273795, -122.470122142574)
183071 129986 2 11 355 Leavenworth St 2 1 1 1     4 Width 4ft   6008451.705569999 2113763.66062 37.7844692288282 -122.414474312134 (37.7844692288282, -122.414474312134)
183017 192713 2 11 1241 Oakdale Ave 5 1 1 1     13 Width 4ft   6017134.34835 2093897.4434200001 37.7304047158846 -122.38305190094401 (37.7304047158846, -122.383051900944)
182978 229108 2 11 1381 South Van Ness Ave 1 1 1 1     17 Width 4ft   6007750.358469999 2101656.23053 37.7511856373284 -122.416043019385 (37.7511856373284, -122.416043019385)
182954 202646 2 11 1735 Alameda St 4 1 1 1     15 Width 3ft   6011282.956669999 2107891.8278799998 37.7685051814939 -122.404265682213 (37.7685051814939, -122.404265682213)
182945 200414 2 11 1020 Minna St 1 4 1 1     6 Width 3ft   6007716.757230001 2109893.6357299997 37.7738017539805 -122.41674272608999 (37.7738017539805, -122.41674272609)
182935 202667 2 11 218 De Haro St 11 1 1 1     6 Width 3ft   6011931.6063 2107639.73611 37.7678492186945 -122.40200432166701 (37.7678492186945, -122.402004321667)
182914 201399 2 11 1051 Ingalls St 11 4 1 1     1 Width 3ft   6018101.39877 2094718.1086 37.732711490446206 -122.3797656316 (37.7327114904462, -122.3797656316)
182913 228036 2 11 3225 22nd St 1 1 1 1     8 Width 3ft   6006862.04153 2103190.1661900003 37.7553474883977 -122.41922372091001 (37.7553474883977, -122.41922372091)
182909 208283 3 11 950x Portola Dr 26 11 1 2     6 Width 3ft   5995702.361819999 2098208.0995400003 37.74103317363429 -122.45745658465401 (37.7410331736343, -122.457456584654)
182877 130101 2 11 151 Leavenworth St 4 1 1 1     2 Width 4ft   6008550.81103 2113028.3188099996 37.7824557240915 -122.414079400045 (37.7824557240915, -122.414079400045)
182852 208214 3 11 1600x Portola Dr 22 11 1 2     8 Width 3ft   5992270.30355 2096715.89094 37.7367382129937 -122.46921470239599 (37.7367382129937, -122.469214702396)
182839 228035 2 11 3283 23rd St 5 1 1 1     10 Width 3ft   6007204.60333 2102624.50037 37.753813585840795 -122.417998937803 (37.7538135858408, -122.417998937803)
Powered by Datasette · Query took 2.725ms · Data source: data.sfgov.org