sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
128 212622 2 16 115 Beverly St 1 9 1 1     4 Width 10ft   5991392.0 2089980.0 37.718192344870296 -122.471760605115 (37.7181923448703, -122.471760605115)
303 196320 2 16 905 Minna St 2 1 1 1     7 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
407 248462 1 16 130 Beulah St 1 1 1 1     9 Width 0ft Permit Number 779787 5997458.097999999 2107812.3026 37.767504613553 -122.45207869525 (37.767504613553, -122.45207869525)
450 142159 2 16 490X Baker St 1 1 1 1     2 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
482 142326 2 16 1652 Hayes St 1 1 1 1     6 Width 0ft   5999940.0 2110256.0 37.774356244626205 -122.44366972691601 (37.7743562446262, -122.443669726916)
924 214223 2 16 207 Mangels Ave 1 1 1 1     3 Width 3ft   5999983.92895 2095213.9818900002 37.7330570333525 -122.44243762501199 (37.7330570333525, -122.442437625012)
1087 236728 2 16 1616 Castro St 2 1 1 1     9 Width 3ft   6002564.10416 2100703.66645 37.7482771632622 -122.433909544687 (37.7482771632622, -122.433909544687)
1535 28642 3 16 1300 Webster St 4 11 1 2     10 20   6003705.0759 2113297.4854 37.782921429068395 -122.430862736641 (37.7829214290684, -122.430862736641)
1658 245160 2 16 101 Lyon St 1 1 1 1     4 Width 0ft   6000314.5004 2109304.1699 37.7717641118423 -122.4423059193 (37.7717641118423, -122.4423059193)
1660 245161 2 16 101 Lyon St 2 1 1 1     5 Width 0ft   6000318.8213 2109280.9033 37.7717004738838 -122.442289302515 (37.7717004738838, -122.442289302515)
1661 245154 2 16 100 Lyon St 3 1 1 1     5 Width 0ft   6000359.4788 2109307.5305 37.771775902629706 -122.44215057779499 (37.7717759026297, -122.442150577795)
1663 251645 2 16 132 Shipley St 2 1 1 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
1669 245155 2 16 100 Lyon St 4 1 1 1     5 Width 0ft   6000354.8127 2109347.659 37.7718858194659 -122.442169599164 (37.7718858194659, -122.442169599164)
1670 251646 2 16 132 Shipley St 3 1 1 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
1675 245153 2 16 100 Lyon St 2 1 1 1     4 Width 0ft   6000359.9454 2109295.8652 37.7717438992436 -122.44214812628701 (37.7717438992436, -122.442148126287)
1677 251644 2 16 132 Shipley St 1 1 1 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
1681 246983 2 16 38 Clipper St 2 1 1 1     10 Width 4ft Permit Number 779954 6004884.234759999 2101078.02552 37.7494364577399 -122.42591323621201 (37.7494364577399, -122.425913236212)
1684 236727 2 16 1616 Castro St 1 1 1 1     11 Width 3ft Permit Number 779934 6002562.04117 2100731.79845 37.7483542900352 -122.43391868899201 (37.7483542900352, -122.433918688992)
1716 236992 2 16 300x Bennington St 1 1 1 1     3 Width 3ft   6007066.0 2096791.0 37.7377883043483 -122.418064736265 (37.7377883043483, -122.418064736265)
1896 236582 2 16 607 Florida St 2 1 1 1     12 Width 4ft Permit Number 779645 6009292.7773400005 2105398.5203400003 37.7615477221736 -122.410973441191 (37.7615477221736, -122.410973441191)
2113 2684 1 16 2100 Bush St 2 1 1 1     8 3X3   6003399.8502 2114890.5748 37.787278352566105 -122.432032487909 (37.7872783525661, -122.432032487909)
2174 113405 2 16 2120 Polk St 1 1 1 1     4 3x3   6006435.39008 2118126.47056 37.796334942346 -122.42176007795901 (37.796334942346, -122.421760077959)
2396 135722 2 16 2498X Pierce St 5 1 1 1     3 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064)
2420 135721 2 16 2498X Pierce St 2 1 1 1     7 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064)
3019 20034 3 16 100 STAIRWAY51 5 1 1 2     3 ST            
3039 236868 2 16 101 Downey St 3 1 1 1     7 Width 3ft   5998866.62555 2107543.5611799997 37.7668472992937 -122.44718746183901 (37.7668472992937, -122.447187461839)
3446 245003 2 16 1201 Page St 1 1 1 1     3 Width 0ft   6000711.7175 2109261.453 37.771669453199294 -122.440928858006 (37.7716694531993, -122.440928858006)
3513 247938 4 16 29 Joy St 1 14 1 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
3523 253474 4 16 134 Lunado Way 1 9 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3541 253472 2 16 134 Lunado Way 1 1 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3548 253473 2 16 134 Lunado Way 2 1 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3600 246903 1 16 491 Frederick St 1 1 1 1     6 Width 3ft   5997265.5984 2107392.9739200003 37.7663422157406 -122.452714254467 (37.7663422157406, -122.452714254467)
3601 246904 1 16 491 Frederick St 2 18 1 1     6 Width 3ft   5997307.10356 2107397.6585 37.7663574565623 -122.452571034738 (37.7663574565623, -122.452571034738)
3644 196082 2 16 701 22nd St 3 1 1 1     1 Width 3ft   6015721.57305 2103923.0720900004 37.7578548576382 -122.388635680008 (37.7578548576382, -122.388635680008)
3675 237732 2 16 4059 17th St 1 1 1 1     6 Width 3ft   6001898.0 2105817.0 37.7622793253591 -122.436578855242 (37.7622793253591, -122.436578855242)
3951 20035 3 16 100 STAIRWAY51 6 1 1 2     3 ST            
4158 253614 2 16 1959x Polk St 1 1 1 1       3x3   6006418.0 2117595.0 37.794874677003605 -122.421782481899 (37.7948746770036, -122.421782481899)
4486 235699 2 16 301 Webster St 2 1 1 1     6 Width 3ft   6004133.22198 2109878.38027 37.773557659984895 -122.42913766099 (37.7735576599849, -122.42913766099)
4558 142520 3 16 301 FRANCISCO ST 3 1 1 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145)
4605 142542 3 16 301 FRANCISCO ST 1 1 1 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453)
4611 142519 3 16 301 FRANCISCO ST 2 1 1 4     6 Width 0ft   6009452.9889 2121171.5596 37.804865708173104 -122.411533760714 (37.8048657081731, -122.411533760714)
4622 142543 3 16 301 FRANCISCO ST 5 1 1 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924)
4731 237544 2 16 25 Ford St 1 1 1 1     12 7x8   6003442.2831 2105633.6495 37.76186352451221 -122.43122467539801 (37.7618635245122, -122.431224675398)
5249 243309 2 16 780 South Van Ness Ave 2 1 1 1     0 Width 3ft   6007491.9091300005 2105126.68883 37.760700186689796 -122.41718265916799 (37.7607001866898, -122.417182659168)
5254 253839 3 16 94 Cortland Ave 1 1 1 2       3x3   6006239.0 2097690.0 37.740210176126794 -122.42098789234 (37.7402101761268, -122.42098789234)
5717 115706 2 16 3055 Pacific Ave 1 1 1 1     5 3x3   5999536.24333 2116655.51656 37.7919046220513 -122.445526661347 (37.7919046220513, -122.445526661347)
6090 105252 1 16 1875 Union St 2 1 1 1         Permit Number 770851 6004061.8803 2118683.0933 37.7977291534815 -122.43001264475201 (37.7977291534815, -122.430012644752)
7408 19027 3 16 3170 Sacramento St 1 1 1 2     12 2x2   5999630.40201 2115407.06556 37.7884820784247 -122.44511107923 (37.7884820784247, -122.44511107923)
7527 20039 3 16 100 STAIRWAY51 10 1 1 2     3 ST            
7538 2644 1 16 1911 Bush St 2 1 1 1     6 4X4   6004293.9749 2114957.7562 37.787513465908496 -122.42894379742201 (37.7875134659085, -122.428943797422)
7618 2643 1 16 1911 Bush St 1 1 1 1     6 4X4   6004268.353999999 2114955.8815 37.7875068682146 -122.429032306872 (37.7875068682146, -122.429032306872)
7944 114576 1 16 3600 Washington St 2 1 1 1     5 6x7   5997488.7199800005 2115765.45327 37.7893436424566 -122.452546800688 (37.7893436424566, -122.452546800688)
8439 19025 3 16 3170 Sacramento St 4 5 1 2     8 2X2   5999621.132119999 2115414.4338700003 37.7885017807754 -122.445143681435 (37.7885017807754, -122.445143681435)
8834 113406 2 16 2120 Polk St 2 1 1 1     5 3x3   6006433.268180001 2118140.51551 37.796373386588606 -122.42176841830201 (37.7963733865886, -122.421768418302)
8873 8201 3 16 1360 Fulton St 1 1 1 2     30 3X3   6001243.6294 2111120.8056 37.7768050488635 -122.439222237812 (37.7768050488635, -122.439222237812)
9526 14741 3 16 900 Pierce St 1 1 1 2     12 4X4   6002478.8616 2111661.3163 37.7783593683998 -122.434987870066 (37.7783593683998, -122.434987870066)
9608 16823 3 16 2139X O'Farrell St 3 1 1 2     6 4X4   6001040.8337 2113118.4303 37.7822784765294 -122.440067043321 (37.7822784765294, -122.440067043321)
10122 173861 2 16 4618 19th St 1 1 1 1       3x3   6000547.0 2104681.0 37.7590832830794 -122.441169935678 (37.7590832830794, -122.441169935678)
10575 20040 3 16 100 STAIRWAY51 11 1 1 2     6 ST            
11228 27092 1 16 717 Silver Ave 2 1 1 1     6 2X3   6006103.20931 2093594.9436599999 37.728958403708894 -122.42116669629699 (37.7289584037089, -122.421166696297)
11578 27091 1 16 717 Silver Ave 1 1 1 1     6 2X3   6006120.2550800005 2093595.10299 37.7289598021321 -122.42110777902398 (37.7289598021321, -122.421107779024)
11812 20044 3 16 100 STAIRWAY51 15 1 1 2     3 ST            
12256 26978 1 16 532 Silver Ave 1 1 1 1     6 3X3   6004762.815690001 2093485.8585299999 37.7285832245248 -122.42579277741001 (37.7285832245248, -122.42579277741)
12976 20042 3 16 100 STAIRWAY51 13 1 1 2     3 ST            
13533 116188 2 16 1751 Carroll Ave 6 1 1 1     1 3x3   6013460.33766 2092361.8798900002 37.725984673034795 -122.395646018568 (37.7259846730348, -122.395646018568)
13588 26008 1 16 1625 Oakdale Ave 1 1 1 1     12 3X3   6014811.10476 2095618.3620200001 37.7350013613099 -122.391203993568 (37.7350013613099, -122.391203993568)
14318 17462 1 16 2022 Palou Ave 1 1 1 1     6 3X3   6012632.03621 2096963.3752099997 37.7385733165067 -122.398832221241 (37.7385733165067, -122.398832221241)
14563 116184 2 16 1751 Carroll Ave 2 1 1 1     1 3x15   6013385.98536 2092427.1118400001 37.7261596505439 -122.395907620544 (37.7261596505439, -122.395907620544)
14695 20043 3 16 100 STAIRWAY51 14 1 1 2     3 ST            
14896 100885 2 16 91 Welsh St 4 1 1 1     6 3x3   6013481.274680001 2111873.9835900003 37.779561876626296 -122.396941070175 (37.7795618766263, -122.396941070175)
14968 26618 3 16 1295 Bay Shore Blvd 1 1 1 2     6 3X3   6011596.48977 2093221.8488599998 37.7282421152608 -122.402149690774 (37.7282421152608, -122.402149690774)
15470 116187 2 16 1751 Carroll Ave 5 1 1 1     1 3x15   6013439.38211 2092375.3069099998 37.7260203752154 -122.395719401447 (37.7260203752154, -122.395719401447)
15502 119264 1 16 1243 19th St 2 1 1 1     5 3x3   6013843.6616400005 2105220.96082 37.7613143247043 -122.39522124448798 (37.7613143247043, -122.395221244488)
15547 100883 2 16 91 Welsh St 2 1 1 1     6 3x3   6013382.01151 2111778.63358 37.779294541435796 -122.397277778167 (37.7792945414358, -122.397277778167)
15803 11415 3 16 1486 Innes Ave 2 1 1 2     12 3X4   6016124.41895 2096811.6938599998 37.7383508053301 -122.386746549719 (37.7383508053301, -122.386746549719)
15827 100893 2 16 91 Welsh St 12 1 1 1     6 3x3   6013651.46361 2112030.89517 37.7800021918959 -122.396363310639 (37.7800021918959, -122.396363310639)
16028 11414 3 16 1486 Innes Ave 1 1 1 2     6 3X4   6016137.01095 2096800.6040700001 37.738321052161005 -122.386702239228 (37.738321052161, -122.386702239228)
16101 100887 2 16 91 Welsh St 6 1 1 1     6 3x3   6013527.06662 2111917.77164 37.7796846574549 -122.39678572578899 (37.7796846574549, -122.396785725789)
16275 116186 2 16 1751 Carroll Ave 4 1 1 1     1 3x3   6013421.91014 2092392.0296900002 37.726065320631896 -122.39578097261699 (37.7260653206319, -122.395780972617)
16551 116185 2 16 1751 Carroll Ave 3 1 1 1     1 3x15   6013402.92261 2092407.9070599999 37.7261078603777 -122.395847723887 (37.7261078603777, -122.395847723887)
16625 100886 2 16 91 Welsh St 5 1 1 1     6 3x3   6013501.81999 2111894.49362 37.7796193360911 -122.396871432992 (37.7796193360911, -122.396871432992)
16894 26124 3 16 1439 Oakdale Ave 1 1 1 2     12 3X3   6015892.5497 2094809.562 37.732840515342104 -122.387408617446 (37.7328405153421, -122.387408617446)
17273 10114 3 16 827 Guerrero St 2 1 1 2     12 3x3   6005696.25247 2104120.31934 37.7578357488369 -122.423321494416 (37.7578357488369, -122.423321494416)
17320 10141 3 16 906 Guerrero St 2 1 1 2     12 2x2   6005654.69613 2103615.0906 37.7564461631881 -122.423429297021 (37.7564461631881, -122.423429297021)
17392 10106 3 16 785 Guerrero St 1 1 1 2     12 2X2   6005679.329609999 2104414.6071 37.7586428391006 -122.42340094141399 (37.7586428391006, -122.423400941414)
17636 10167 3 16 1021 Guerrero St 1 1 1 2     12 2X2   6005764.985230001 2102811.5808900003 37.7542461363638 -122.422990770503 (37.7542461363638, -122.422990770503)
17729 10111 1 16 817 Guerrero St 1 1 1 1     6 2x2   6005691.67507 2104204.22323 37.758065870971706 -122.423343289458 (37.7580658709717, -122.423343289458)
17743 9991 3 16 43 Guerrero St 1 1 1 2     6 2X2   6005443.377280001 2108628.68203 37.7702003684767 -122.424516723968 (37.7702003684767, -122.424516723968)
18253 4301 1 16 4374 Cesar Chavez St 1 1 1 1     6 3X3   6001502.87912 2100307.76951 37.7471298441855 -122.43755087718 (37.7471298441855, -122.43755087718)
18523 18424 3 16 974 Potrero Ave 1 1 1 2     6 3X3   6010455.61637 2103584.4912099997 37.7566319433297 -122.40682378579099 (37.7566319433297, -122.406823785791)
18701 22848 1 16 120 Turquoise Way 4 1 1 1     20 1X1   5999801.2823 2099039.75864 37.743551298748 -122.44334377921601 (37.743551298748, -122.443343779216)
18880 25589 1 16 1380X Cortland Ave 1 1 1 1     40 3X3   6009160.7320011 2097455.9675674997 37.7397318376167 -122.410869155933 (37.7397318376167, -122.410869155933)
18974 10193 1 16 1170 Guerrero St 1 1 1 1     10 2x2   6005736.259869999 2102154.58599 37.752440559408896 -122.42304341594699 (37.7524405594089, -122.423043415947)
19048 10142 1 16 915 Guerrero St 1 1 1 1     6 2x2   6005723.61297 2103645.6305400003 37.7565339082426 -122.42319312877599 (37.7565339082426, -122.423193128776)
19264 10115 3 16 827 Guerrero St 3 1 1 2     3 3x3   6005698.17392 2104144.57278 37.75790245155879 -122.42331657330901 (37.7579024515588, -122.423316573309)
19389 9994 3 16 102 Guerrero St 1 1 1 2     12 2X2   6005389.27087 2108406.08421 37.7695861126487 -122.424688040346 (37.7695861126487, -122.424688040346)
19522 17054 3 16 1267 Oak St 1 1 1 2     12 3X3   6000942.0344 2109636.8826 37.77271340359871 -122.44015910616301 (37.7727134035987, -122.440159106163)
19524 8290 3 16 50 Garcia Ave 2 11 1 2     30 8   5995181.45452 2099378.2291200003 37.7442161243666 -122.45934239824899 (37.7442161243666, -122.459342398249)
19736 121676 2 16 65 Sotelo Ave 1 1 1 1       3x3   5993867.0 2101351.0 37.7495571916966 -122.464030639739 (37.7495571916966, -122.464030639739)
19778 10042 3 16 360 Guerrero St 5 1 1 2     20 3X3   6005475.5325 2106875.27322 37.7653877427782 -122.424280773365 (37.7653877427782, -122.424280773365)
19854 22847 1 16 120 Turquoise Way 3 1 1 1     16 1X1   5999792.57079 2099032.92975 37.7435320514679 -122.44337341096 (37.7435320514679, -122.44337341096)
Powered by Datasette · Query took 40.329ms · Data source: data.sfgov.org