sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
256 221894 2 68 3164 25th St 2 1 1 1     10 Width 3ft   6008618.9330400005 2101573.97925 37.75100859049479 -122.41303356944799 (37.7510085904948, -122.413033569448)
260 221893 2 68 3164 25th St 3 1 1 1     12 Width 3ft   6008601.79804 2101572.78068 37.751004337584796 -122.41309273944599 (37.7510043375848, -122.413092739446)
509 38234 1 68 0 16th St 4 1 1 1   07/21/1998 12:00:00 AM     Permit Number 40352          
1016 225959 1 68 20 Newman St 2 1 1 1   09/15/2005 12:00:00 AM 12 Width 3ft Permit Number 48238 6006979.14621 2096796.63822 37.7377988968125 -122.41836543223101 (37.7377988968125, -122.418365432231)
1698 225957 2 68 38 Newman St 1 1 1 1     10 Width 3ft   6007027.0 2096768.0 37.7377229562927 -122.418197948284 (37.7377229562927, -122.418197948284)
2992 43017 1 68   2 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42880          
3164 10171 1 68 1032 Guerrero St 1 1 1 1   08/23/2017 12:00:00 AM 3 2x3 Permit Number 779560 6005695.79144 2102951.17521 37.7546255252659 -122.423239982539 (37.7546255252659, -122.423239982539)
3545 43015 1 68   1 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42880          
3668 43018 1 68   3 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42880          
4219 244047 2 68 400 Cole St 1 1 1 1     2 Width 0ft   5997955.5586 2109119.1735 37.771121429752895 -122.450452276113 (37.7711214297529, -122.450452276113)
4435 34068 1 68 955 Kennedy Ave 2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37965          
5326 38231 1 68 0 16th St 2 1 1 1   07/21/1998 12:00:00 AM     Permit Number 40352          
5586 43016 1 68   4 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42880          
5795 10694 3 68 1250 Hayes St 2 1 1 2     12 3X3   6001838.4236 2110502.6134 37.7751414763631 -122.43712039839399 (37.7751414763631, -122.437120398394)
6485 29768 3 68 640 Francisco St 1 1 1 2   01/01/1991 12:00:00 AM 6 6x6   6008286.5569 2121053.0319999997 37.8044747652934 -122.415561939011 (37.8044747652934, -122.415561939011)
6607 34069 1 68 955 Kennedy Ave 3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37965          
6875 26546 3 68 570 Francisco St 1 1 1 2   06/19/1997 12:00:00 AM 6 4X4   6008578.3106 2121094.8201 37.804605899968 -122.41455525494301 (37.804605899968, -122.414555254943)
7043 34072 1 68 955 Kennedy Ave 6 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37965          
7187 22760 3 68 1620 Turk St 2 1 1 2     3 4X4   6002287.3238 2112301.156 37.7801053300032 -122.43569625863701 (37.7801053300032, -122.435696258637)
7921 29760 3 68 500 Francisco St 3 1 1 2     6 3x3   6008840.5335 2121127.883 37.804711410621294 -122.41365014448401 (37.8047114106213, -122.413650144484)
7991 38232 1 68 0 16th St 1 1 1 1   07/21/1998 12:00:00 AM     Permit Number 40352          
9590 34067 1 68 955 Kennedy Ave 1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37965          
9818 46930 1 68 1 Pacheco St 3 1 1 1 1 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.743524195830396 -122.459369067857 (37.7435241958304, -122.459369067857)
9820 46927 1 68 1 Pacheco St 1 1 1 1 1 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.743524195830396 -122.459369067857 (37.7435241958304, -122.459369067857)
9821 46929 1 68 1 Pacheco St 2 1 1 1 1 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.743524195830396 -122.459369067857 (37.7435241958304, -122.459369067857)
9825 46928 1 68 1 Pacheco St 4 1 1 1   12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.743524195830396 -122.459369067857 (37.7435241958304, -122.459369067857)
9953 107188 1 68 1500 PAGE ST 3 1 1 1   09/15/2014 12:00:00 AM 3 3x3 Permit Number 773122 5999274.2 2109122.8 37.771206769657205 -122.445891326497 (37.7712067696572, -122.445891326497)
10500 34071 1 68 955 Kennedy Ave 5 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37965          
10511 38233 1 68 0 16th St 3 1 1 1   07/21/1998 12:00:00 AM     Permit Number 40352          
10930 109686 1 68 190 Onondaga Ave 1 1 1 1 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 772797 6000260.82873 2091434.8524 37.7226961949641 -122.441209260793 (37.7226961949641, -122.441209260793)
11919 108571 1 68 223 Sweeny St 1 1 1 1 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772573 6009406.56 2094751.33642 37.732319284403204 -122.409828317318 (37.7323192844032, -122.409828317318)
12244 45154 1 68 1683 Precita Ave 1 1 1 1   05/22/2001 12:00:00 AM     Permit Number 44007          
12798 34070 1 68 955 Kennedy Ave 4 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37965          
13344 187697 1 68 1256 Treat Ave 2 1 1 1 1         6008667.10840058 2101226.16540452 37.7500562758063 -122.41284238591601 (37.7500562758063, -122.412842385916)
13345 69222 1 68 1250 Treat Ave 1 1 1 1 1 12/15/2001 12:00:00 AM   3x3 Permit Number 33274 6008665.27491562 2101259.70225891 37.750148257591896 -122.412851097008 (37.7501482575919, -122.412851097008)
13521 49830 1 68 225 Missouri St 1 1 1 1   06/11/2003 12:00:00 AM 5 3x3 Permit Number 46613 6013486.20588 2106002.24827 37.7634396826096 -122.396512309398 (37.7634396826096, -122.396512309398)
13795 78433 2 68 870 Kansas St 1 1 1 1 1 03/09/2016 12:00:00 AM 3     6011558.925919999 2104265.3143 37.7585630053957 -122.403056007737 (37.7585630053957, -122.403056007737)
14322 115881 1 68 1663 La Salle Ave 1 1 1 1   03/01/2016 12:00:00 AM 3   Permit Number 773046 6015043.9945 2096491.0960099997 37.737410632491 -122.39045976502199 (37.737410632491, -122.390459765022)
17382 10079 3 68 614 Guerrero St 1 1 1 2     50 3X3   6005561.0033 2105378.47551 37.7612827162343 -122.423878706238 (37.7612827162343, -122.423878706238)
17464 10037 1 68 351 Guerrero St 1 1 1 1     15 3x2   6005536.7714599995 2106975.8845599997 37.765667455319 -122.424076117338 (37.765667455319, -122.424076117338)
17889 10131 3 68 899 Guerrero St 2 1 1 2   02/04/1992 12:00:00 AM 6 3X3   6005716.194490001 2103799.35315 37.7569555760466 -122.42322971137699 (37.7569555760466, -122.423229711377)
18217 10091 1 68 708 Guerrero St 1 1 1 1   02/07/1992 12:00:00 AM 50 3X3   6005589.43333 2104821.82229 37.759755882347704 -122.42374079792299 (37.7597558823477, -122.423740797923)
18333 27660 3 68 1360 Guerrero St 1 1 1 2     35 3x3   6005798.597080001 2101052.0301599996 37.7494167122272 -122.42274949589199 (37.7494167122272, -122.422749495892)
18959 10130 3 68 899 Guerrero St 1 1 1 2   02/04/1992 12:00:00 AM 6 3X3   6005717.32362 2103778.4665900003 37.7568982901448 -122.423224321766 (37.7568982901448, -122.423224321766)
19073 10152 3 68 981 Guerrero St 1 1 1 2     6 3X3   6005742.33218 2103287.1896599997 37.7555507693625 -122.42310291418801 (37.7555507693625, -122.423102914188)
19086 10155 3 68 988 Guerrero St 1 1 1 2     12 2x2   6005676.86794 2103220.79798 37.7553647787894 -122.423324590769 (37.7553647787894, -122.423324590769)
19478 10071 3 68 563 Guerrero St 1 1 1 2     12 2x3   6005607.25335 2105721.20389 37.7622263784702 -122.423743116346 (37.7622263784702, -122.423743116346)
19491 10032 1 68 315 Guerrero St 1 1 1 1     6 3X2   6005527.20527 2107119.43239 37.7660610633959 -122.424119414293 (37.7660610633959, -122.424119414293)
19662 10000 1 68 136 Guerrero St 1 1 1 1     90 2X2   6005403.547780001 2108183.22689 37.7689750062251 -122.424622801709 (37.7689750062251, -122.424622801709)
19692 65477 1 68 400 Faxon Ave 1 1 1 1 1 12/12/1989 12:00:00 AM     Permit Number 28358 5994782.15079154 2091255.17859292 37.7218892499679 -122.46013471597601 (37.7218892499679, -122.460134715976)
19723 26529 3 68 2747 Harrison St 1 1 1 2     10 3x3   6008970.13177 2102467.22828 37.75348096079001 -122.41188219893101 (37.75348096079, -122.411882198931)
20077 115127 1 68 499X MAIN ST 5 1 1 1     6     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
20120 10020 1 68 250 Guerrero St 1 1 1 1     32 2x2   6005442.42406 2107520.98643 37.767158847823 -122.42444122050101 (37.767158847823, -122.424441220501)
20175 10089 3 68 700 Guerrero St 1 1 1 2     80 3X3   6005586.51976 2104851.24563 37.7598365074586 -122.423752966647 (37.7598365074586, -122.423752966647)
20284 10112 3 68 821 Guerrero St 1 1 1 2     6 3x3   6005694.086069999 2104163.28117 37.7579535897166 -122.423332040744 (37.7579535897166, -122.423332040744)
20351 10165 3 68 1019 Guerrero St 1 1 1 2     18 3x4   6005763.39401 2102897.6669099997 37.7544824188306 -122.423002391551 (37.7544824188306, -122.423002391551)
20893 10068 3 68 549 Guerrero St 1 1 1 2     12 2x3   6005603.73706 2105778.3330099997 37.762383043055 -122.423759340124 (37.762383043055, -122.423759340124)
21251 10061 3 68 490 Guerrero St 1 1 1 2     60 2X2   6005517.65207 2106131.14555 37.7633469229371 -122.424082167969 (37.7633469229371, -122.424082167969)
21466 10087 1 68 673 Guerrero St 1 1 1 1     18 2X2   6005642.33302 2105078.4944700003 37.7604636299235 -122.423576092482 (37.7604636299235, -122.423576092482)
21505 10026 1 68 290 Guerrero St 1 1 1 1     24 2x3   6005455.03663 2107324.1386599997 37.7666190630424 -122.424383592842 (37.7666190630424, -122.424383592842)
21573 10054 3 68 426 Guerrero St 1 1 1 2     80 3X2   6005501.955709999 2106458.62904 37.764245228771 -122.42415974799201 (37.764245228771, -122.424159747992)
21621 10076 3 68 600 Guerrero St 1 1 1 2     70 2x2   6005555.84644 2105437.30746 37.7614439637781 -122.423900725242 (37.7614439637781, -122.423900725242)
21713 10001 3 68 145 Guerrero St 1 1 1 2     12 3X2   6005474.27283 2108090.23028 37.768723653813204 -122.42437155270201 (37.7687236538132, -122.424371552702)
21782 10227 3 68 1404 Guerrero St 1 1 1 2     50 3x3   6005821.31625 2100751.5734599996 37.7485930087737 -122.422649583919 (37.7485930087737, -122.422649583919)
21827 26513 3 68 2864 Harrison St 1 1 1 2     35 3X3   6008948.96043 2101783.0813599997 37.7516012590109 -122.41190707235701 (37.7516012590109, -122.411907072357)
22152 10132 3 68 899 Guerrero St 3 1 1 2   02/04/1992 12:00:00 AM 6 3X3   6005714.0796 2103814.39751 37.756996764997 -122.42323809485599 (37.756996764997, -122.423238094856)
23948 32109 1 68 431 Noe St 2 1 1 1 1 08/09/1995 12:00:00 AM 11   Permit Number 35479 6002988.87793 2105732.43045 37.7621090484283 -122.43279988020299 (37.7621090484283, -122.432799880203)
24547 83274 2 68 1639X Taylor St 2 1 1 1 1 01/21/2006 12:00:00 AM 5     6008741.72565 2118600.6509700003 37.7977667125146 -122.41381320433001 (37.7977667125146, -122.41381320433)
24867 128872 2 68 1270 Clay St 2 9 1 1     3 Width 3ft   6008617.8933 2116985.80522 37.7933257892186 -122.414127394165 (37.7933257892186, -122.414127394165)
24972 49768 1 68 333 Schwerin St 6 1 1 1 1 06/04/2003 12:00:00 AM 7   Permit Number 46559 6008671.05987 2086426.1944 37.7094189460104 -122.411783070238 (37.7094189460104, -122.411783070238)
25421 192408 2 68 799 Kansas St 1 1 1 1     11 Width 3ft   6011594.92882 2104699.3900200003 37.759756891395796 -122.40296202319999 (37.7597568913958, -122.4029620232)
25801 225955 2 68 245 Roanoke St 3 1 1 1     1 Width 3ft   6003637.7380800005 2095933.74555 37.735240927214704 -122.42985676608299 (37.7352409272147, -122.429856766083)
26692 219004 2 68 1655 09th Ave 1 1 1 1     25 Width 3ft   5993378.4627 2104217.9895 37.7574010390349 -122.46592829725 (37.7574010390349, -122.46592829725)
26806 34502 1 68 1415 20th St 1 1 1 1 1 07/17/1997 12:00:00 AM 9   Permit Number 38224 6013698.3172 2104744.62684 37.759998331483494 -122.39569055749399 (37.7599983314835, -122.395690557494)
27086 225956 2 68 126 Fairmount St 1 1 1 1     4 Width 3ft   6004690.92985 2097272.0847099996 37.738975290087104 -122.426310750952 (37.7389752900871, -122.426310750952)
27127 225952 2 68 800 Alvarado St 1 1 1 1     7 Width 3ft   6001178.257669999 2102625.59939 37.753475588250396 -122.438839459988 (37.7534755882504, -122.438839459988)
27884 225899 2 68 1398 Bryant St 2 1 1 1     11 Width 4ft   6009375.43724 2107898.5512099997 37.7684168680618 -122.41086412858 (37.7684168680618, -122.41086412858)
28224 48556 1 68 615 Central Ave 1 1 1 1 1 08/23/2002 12:00:00 AM 3   Permit Number 45872 5999645.29400405 2110579.50430317 37.7752276921804 -122.444712423834 (37.7752276921804, -122.444712423834)
28376 66066 1 68 1431 20th St 1 1 1 1 1 08/06/1990 12:00:00 AM 11   Permit Number 29106 6013625.10181 2104739.90322 37.7599812884231 -122.395943445033 (37.7599812884231, -122.395943445033)
28449 113387 1 68 185 CASTENADA AVE 1 1 1 1     3     5994493.0 2100782.0 37.7480309194949 -122.461824674651 (37.7480309194949, -122.461824674651)
28869 83275 2 68 1639X Taylor St 1 1 1 1 1 01/21/2006 12:00:00 AM 5     6008740.14676 2118614.90766 37.797805769189296 -122.413819676732 (37.7978057691893, -122.413819676732)
29018 247759 2 68 75 Alpine Ter 1 4 1 1     10 Width 3ft   6001668.74952 2108376.80716 37.7692948959648 -122.437555068929 (37.7692948959648, -122.437555068929)
29070 225918 2 68 1619 Alabama St 1 1 1 1     9 Width 3ft   6009320.793740001 2100001.018 37.746728962386705 -122.41049539576001 (37.7467289623867, -122.41049539576)
29808 225970 2 68 2846 22nd St 1 1 1 1     14 Width 3ft   6009214.745180001 2103362.9385 37.7559541000213 -122.411099534231 (37.7559541000213, -122.411099534231)
29911 245456 2 68 2800 16th St 2 1 1 1     13 Width 0ft   6007901.4813 2106811.8898 37.765350391343496 -122.415885464882 (37.7653503913435, -122.415885464882)
30003 219010 2 68 157 Miramar Ave 1 1 1 1     3 Width 3ft   5995318.0566300005 2090927.8253099998 37.7210212256375 -122.458258556898 (37.7210212256375, -122.458258556898)
31008 49769 1 68 333 Schwerin St 4 1 1 1 1 06/04/2003 12:00:00 AM 4   Permit Number 46559 6008658.89925 2086391.1157900002 37.70932194511621 -122.411822622426 (37.7093219451162, -122.411822622426)
31018 244415 2 68 630 Page St 1 1 1 1     2 Width 0ft   6003443.0612 2109684.1199 37.7729851758016 -122.43151115772899 (37.7729851758016, -122.431511157729)
31199 176506 2 68 178 Brookdale Ave 6 9 1 1     6 Width 6ft   6005608.52394 2087094.5334400001 37.7110817807597 -122.42241517113001 (37.7110817807597, -122.42241517113)
31526 95134 1 68 450@ Wayland Somerset St 3 1 1 1     1 3x3   6010117.366119999 2092259.39432 37.7255167458877 -122.40719528853501 (37.7255167458877, -122.407195288535)
31692 219005 2 68 1838 11th Ave 1 1 1 1     4 Width 2ft   5992852.04405 2102933.06242 37.7538425808737 -122.467655401194 (37.7538425808737, -122.467655401194)
32129 225911 2 68 886 Guerrero St 2 1 1 1     12 Width 4ft   6005643.7507 2103817.72642 37.75700193611971 -122.42348155572999 (37.7570019361197, -122.42348155573)
33224 32625 1 68 75 Boardman Pl 1 1 1 1 1 10/23/1996 12:00:00 AM 15   Permit Number 37080 6011878.08124 2109949.48586 37.774188278987204 -122.402351882652 (37.7741882789872, -122.402351882652)
33404 225968 2 68 3599 24th St 3 1 1 1     20 Width 3ft   6005865.3441 2101966.56287 37.751931574603894 -122.422583660903 (37.7519315746039, -122.422583660903)
33600 49767 1 68 333 Schwerin St 7 1 1 1 1 06/04/2003 12:00:00 AM 7   Permit Number 46559 6008676.28834 2086439.38255 37.7094554512839 -122.41176593097 (37.7094554512839, -122.41176593097)
35324 245162 2 68 1308 Page St 1 1 1 1     5 Width 0ft   6000247.8581 2109240.6853 37.7715860006418 -122.44253187989901 (37.7715860006418, -122.442531879899)
35468 49765 1 68 333 Schwerin St 3 1 1 1 1 06/04/2003 12:00:00 AM 5   Permit Number 46559 6008653.27394 2086377.17589 37.7092833534188 -122.411841080097 (37.7092833534188, -122.411841080097)
35780 128877 3 68 1237x Robert C Levy Tunl 6 3 1 2     3     6007635.0884300005 2118146.70213 37.796458073045 -122.417610293998 (37.796458073045, -122.417610293998)
35910 219003 2 68 1461 07th Ave 1 1 1 1     5 Width 2ft   5993948.08517 2105555.3752599997 37.7611059976579 -122.464055414128 (37.7611059976579, -122.464055414128)
36158 65448 1 68 72 05th Ave 1 1 1 1   11/08/1989 12:00:00 AM 9   Permit Number 28322 5994279.76671 2115099.7417900003 37.7873314010144 -122.46360098807399 (37.7873314010144, -122.463600988074)
36558 225906 2 68 3749 25th St 1 1 1 1     15 Width 3ft   6005541.4535 2101364.78602 37.750260956187404 -122.423660939909 (37.7502609561874, -122.423660939909)
Powered by Datasette · Query took 2.1ms · Data source: data.sfgov.org