sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
168 179480 2 25 100 Serrano Dr 1 2 1 1     11     5989599.0 2090767.0 37.7202493457345 -122.478015677124 (37.7202493457345, -122.478015677124)
455 234501 3 3 2423 Market St 2 2 1 2     12 Width 8ft   6002117.5892 2105782.84009 37.7621980066439 -122.435816935712 (37.7621980066439, -122.435816935712)
565 206617 2 66 198 Garcia Ave 1 2 1 1     8 Width 3ft   5994686.63181 2099351.09779 37.7441131663853 -122.461051409618 (37.7441131663853, -122.461051409618)
608 233928 2 100 8 Octavia St Frontage East 1 2 1 1     29 Width 8ft   6005775.18179 2109348.30824 37.77219502161479 -122.423420179704 (37.7721950216148, -122.423420179704)
721 183636 4 108 1478 47th Ave 1 2 1 1     4 3x9   5981570.9282 2105017.3718 37.7589076903569 -122.506822015648 (37.7589076903569, -122.506822015648)
789 175382 3 53 80x Junipero Serra Blvd 19 2 1 2     2 Width 3ft   5991305.518069999 2089124.29272 37.7158377779634 -122.471997198511 (37.7158377779634, -122.471997198511)
854 203901 3 5 3794 19th Ave 3 2 1 2     12 Width 3ft   5990470.121669999 2090714.3108400002 37.720155198286 -122.475000685058 (37.720155198286, -122.475000685058)
892 251400 2 111 101 Rhine St 5 2 1 1       Width 3ft   5994375.43496 2086552.5575599999 37.7089535675334 -122.461199910156 (37.7089535675334, -122.461199910156)
1006 232567 2 2 947 Elizabeth St 2 2 1 1     16 Width 4ft   6000330.76798 2101953.15424 37.751580964011204 -122.441721996685 (37.7515809640112, -122.441721996685)
1009 223537 1 49 1300 Noe St 2 2 1 1     15 Width 5ft   6003218.0959 2100594.3408 37.7480140720016 -122.431640256605 (37.7480140720016, -122.431640256605)
1103 211013 2 71 500 Junipero Serra Blvd 44 2 1 1     3 Width 0ft   5991332.59313 2093509.69784 37.727880584217 -122.47222310103399 (37.727880584217, -122.472223101034)
1368 141257 2 144 51 COMMONWEALTH AVE 3 2 1 1     6 Width 0ft   5996492.2734 2114210.7856 37.7850177994523 -122.455881936455 (37.7850177994523, -122.455881936455)
1370 141258 2 2 51 COMMONWEALTH AVE 8 2 1 1     4 Width 0ft   5996495.6576 2114088.9538 37.7846834760254 -122.455861417999 (37.7846834760254, -122.455861417999)
1785 228278 2 44 2050 15th St 1 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
1857 251765 2 21 23 Seville St 3 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1870 251767 2 21 23 Seville St 5 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1871 176854 2 21 23 Seville St 1 2 1 1     12 Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1876 251766 2 21 23 Seville St 4 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1878 251764 2 12 187 Seville St 4 2 1 1       Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
2066 252868 2 98 15 Foerster St 2 2 1 1       Width 3ft   5998080.65269 2093664.7185 37.7286944544712 -122.44890616611099 (37.7286944544712, -122.448906166111)
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)
2094 252881 2 27 3536 Jennings St 1 2 1 1       Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
2102 196505 2 18 3536 Jennings St 3 2 1 1     2 Width 3ft   6013064.418880001 2089502.0027700001 37.7181099951501 -122.39681428375299 (37.7181099951501, -122.396814283753)
2211 188595 2 5 1301 Rhode Island St 3 2 1 1   07/05/2017 12:00:00 AM 3 Width 7ft   6011997.611930001 2102271.8897 37.7531139870419 -122.401398733477 (37.7531139870419, -122.401398733477)
2383 201821 2 48 100 Friedell St 5 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.4470799998 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782)
2387 201822 2 48 100 Friedell St 6 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.0299200001 37.72884183267921 -122.36952018972299 (37.7288418326792, -122.369520189723)
2402 201606 2 44 598 Innes Ave 1 2 1 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020954.32481 2093200.4635700001 37.7287012794353 -122.36979738594101 (37.7287012794353, -122.369797385941)
2408 201820 2 48 100 Friedell St 4 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.728922786051506 -122.369449472416 (37.7289227860515, -122.369449472416)
2417 201819 2 48 100 Friedell St 3 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
2465 201607 2 44 598 Innes Ave 2 2 1 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020934.32673 2093214.8340900003 37.7287396409072 -122.36986751418699 (37.7287396409072, -122.369867514187)
2611 248770 2 60 1 Cuesta Ct 4 2 1 1     17 Width 8ft   5999726.1375 2101744.56242 37.7509737525388 -122.44379789365499 (37.7509737525388, -122.443797893655)
2614 248773 2 60 1 Cuesta Ct 1 2 1 1     15 Width 8ft   5999776.82694 2101824.96428 37.751197407653706 -122.44362838043999 (37.7511974076537, -122.44362838044)
2625 248771 2 60 1 Cuesta Ct 3 2 1 1     13 Width 8ft   5999742.36883 2101773.9828 37.751055459558394 -122.4437438777 (37.7510554595584, -122.4437438777)
2626 248769 2 60 1 Cuesta Ct 5 2 1 1     14 Width 8ft   5999705.100819999 2101709.8291 37.7508771833507 -122.443868145114 (37.7508771833507, -122.443868145114)
2629 248772 2 60 1 Cuesta Ct 2 2 1 1     27 Width 8ft   5999759.8487 2101799.49731 37.7511265131926 -122.443685263491 (37.7511265131926, -122.443685263491)
2702 175365 2 12 1 Brotherhood Way 18 2 1 1     7 Width 5ft   5993296.25394 2087788.76232 37.712285726578 -122.465019407322 (37.712285726578, -122.465019407322)
2703 175367 2 12 1 Brotherhood Way 23 2 1 1     5 Width 5ft   5993394.31846 2087754.15211 37.7121963492565 -122.464677958129 (37.7121963492565, -122.464677958129)
2705 175366 2 12 1 Brotherhood Way 22 2 1 1     4 Width 5ft   5993316.47827 2087783.2739799998 37.7122718230516 -122.464949108223 (37.7122718230516, -122.464949108223)
2708 175370 2 12 1 Brotherhood Way 26 2 1 1     5 Width 5ft   5993448.13741 2087722.6413599998 37.712112930839 -122.464489658971 (37.712112930839, -122.464489658971)
2709 175364 2 12 1 Brotherhood Way 15 2 1 1     3 Width 5ft   5993263.021319999 2087797.41727 37.7123075747038 -122.465134896479 (37.7123075747038, -122.465134896479)
2716 175362 2 12 1 Brotherhood Way 10 2 1 1     6 Width 5ft   5993185.52762 2087808.44828 37.7123333942447 -122.46540353654 (37.7123333942447, -122.46540353654)
2720 175369 2 12 1 Brotherhood Way 25 2 1 1     3 Width 5ft   5993431.63462 2087732.39125 37.7121387503812 -122.46454740445101 (37.7121387503812, -122.464547404451)
2721 175371 2 12 1 Brotherhood Way 27 2 1 1     3 Width 5ft   5993471.88559 2087712.01586 37.712085124705204 -122.464406808033 (37.7120851247052, -122.464406808033)
2722 175368 2 12 1 Brotherhood Way 24 2 1 1     2 Width 5ft   5993415.10175 2087740.6954 37.7121605985029 -122.464605149022 (37.7121605985029, -122.464605149022)
2814 241583 2 37 38X Java St 2 2 1 1     6 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2837 241584 2 37 38X Java St 3 2 1 1     7 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2841 241585 2 37 38X Java St 4 2 1 1     8 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2940 250421 1 2 49 Seacliff Ave 3 2 1 1     8 Width 4ft   5987880.27353 2115792.69032 37.788863226412296 -122.485792492053 (37.7888632264123, -122.485792492053)
2985 250408 1 2 25 Seacliff Ave 2 2 1 1     12 Width 4ft   5988046.91633 2115796.65095 37.7888838100916 -122.485216228949 (37.7888838100916, -122.485216228949)
2987 250422 1 2 49 Seacliff Ave 4 2 1 1     7 Width 4ft   5987891.12003 2115793.8659200002 37.7888670862959 -122.48575505145399 (37.7888670862959, -122.485755051454)
3017 250423 1 2 49 Seacliff Ave 5 2 1 1     7 Width 4ft   5987905.22883 2115793.56651 37.7888670863011 -122.485706215587 (37.7888670863011, -122.485706215587)
3028 191362 2 195 999 Key Ave 2 2 1 1     27     6013336.3333 2089743.8780099999 37.718789267498295 -122.39589132571999 (37.7187892674983, -122.39589132572)
3029 193472 2 196 1059 Jamestown Ave 1 2 1 1     8     6013665.43892 2089838.8488900003 37.719068342415596 -122.39476037791599 (37.7190683424156, -122.394760377916)
3033 253285 2 141 8245 Geary Blvd 1 2 1 1   08/15/2017 12:00:00 AM 3     5981372.0 2112274.0 37.7788205636315 -122.50804856364901 (37.7788205636315, -122.508048563649)
3040 189089 2 74 1033 Le Conte Ave 2 2 1 1     6     6012956.43123 2089677.63232 37.718586227543504 -122.397199861797 (37.7185862275435, -122.397199861797)
3041 182178 2 28 1799X Lawton St 5 2 1 1     8 Width 0ft   5988865.0 2104441.0 37.7577519603078 -122.48155379203999 (37.7577519603078, -122.48155379204)
3065 175836 2 49 101 Rhine St 3 2 1 1     5 Width 3ft   5994366.585519999 2086543.72285 37.70892880020671 -122.46122985488998 (37.7089288002067, -122.46122985489)
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)
3382 122965 2 141 98 09th Ave 4 2 1 1     5 Width 5ft   5993050.799269999 2114904.9128799997 37.786725565514004 -122.467838745487 (37.786725565514, -122.467838745487)
3405 180669 2 73 171 Winding Way 3 2 1 1     0 Width 6ft   6002170.184219999 2086635.71157 37.70962739445179 -122.434266111507 (37.7096273944518, -122.434266111507)
3411 181033 2 26 39 Curtis St 1 2 1 1     0 Width 4ft   6000587.53239 2088326.47 37.71417988317489 -122.439857163381 (37.7141798831749, -122.439857163381)
3413 180646 2 73 451 Rolph St 1 2 1 1     0 Width 6ft   6002230.18825 2087673.61332 37.7124806510226 -122.434132874236 (37.7124806510226, -122.434132874236)
3423 251752 2 37 128 South Hill Blvd 2 2 1 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3430 180648 2 73 120 Seville St 1 2 1 1     0 Width 6ft   6001751.26715 2087361.8508 37.7115974268507 -122.435765878508 (37.7115974268507, -122.435765878508)
3432 180655 2 37 128 South Hill Blvd 1 2 1 1     31 Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3488 251753 2 37 128 South Hill Blvd 3 2 1 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3734 118035 2 2 450 38th Ave 1 2 1 1     21 Width 4ft   5984123.0 2112760.0 37.7803166927985 -122.498567828267 (37.7803166927985, -122.498567828267)
3768 228283 8 44 2036X 15th St 6 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3773 228285 8 44 2036X 15th St 8 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3775 228281 8 44 2036X 15th St 4 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3776 228280 8 44 2036X 15th St 3 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3780 228286 8 44 2036X 15th St 9 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3781 228284 8 44 2036X 15th St 7 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3791 228279 8 44 2036X 15th St 2 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3795 228282 8 44 2036X 15th St 5 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3800 213446 2 18 530 Magellan Ave 2 2 1 1     5 Width 3ft   5993033.55222 2099443.36305 37.744271238444206 -122.46677405027799 (37.7442712384442, -122.466774050278)
3812 253561 2 44 530 Magellan Ave 1 2 1 1       Width 3ft   5993033.55222 2099443.36305 37.744271238444206 -122.46677405027799 (37.7442712384442, -122.466774050278)
3816 219559 2 119 4 Cortes Ave 6 2 1 1     28 Width 3ft   5993189.55754 2099585.29183 37.7446699411581 -122.46624493416799 (37.7446699411581, -122.466244934168)
3822 253559 2 18 4 Cortes Ave 5 2 1 1       Width 3ft   5993184.39566 2099612.1282900004 37.7447433294416 -122.46626473273199 (37.7447433294416, -122.466264732732)
3850 207785 2 103 290 Santa Clara Ave 1 2 1 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
3920 216755 2 73 115 Harold Ave 1 2 1 1   10/04/2017 01:38:00 PM 3 Width 3ft   5996789.877280001 2090654.02957 37.720353912480995 -122.453151180205 (37.720353912481, -122.453151180205)
3943 216737 2 49 11 Lee Ave 1 2 1 1   10/04/2017 02:31:00 PM 3 Width 2ft   5996481.70655 2089974.5093900003 37.7184704425356 -122.45416736555799 (37.7184704425356, -122.454167365558)
3959 216642 2 49 50 Lee Ave 1 2 1 1   10/04/2017 01:57:00 PM 3 Width 2ft   5996528.83108 2090217.4765599999 37.7191402755735 -122.45402201441999 (37.7191402755735, -122.45402201442)
3999 181035 2 13 170 Rolph St 1 2 1 1   10/05/2017 04:20:00 PM 3 Width 4ft   6000927.8060099995 2088408.3131900001 37.7144239699579 -122.438686909772 (37.7144239699579, -122.438686909772)
4004 251722 2 26 18 Lobos St 2 2 1 1   10/05/2017 03:08:00 PM 3     5996685.56427 2088703.70423 37.7149927956564 -122.45337101855101 (37.7149927956564, -122.453371018551)
4006 216739 2 11 11 Brighton Ave 1 2 1 1   10/05/2017 08:12:00 AM 3 Width 3ft   5996185.57101 2089978.26988 37.7184637821573 -122.4551912491 (37.7184637821573, -122.4551912491)
4008 216051 2 12 48 Lobos St 1 2 1 1   10/05/2017 02:54:00 PM 3     5996419.4156599995 2088710.03455 37.7149949180514 -122.454291392827 (37.7149949180514, -122.454291392827)
4014 216033 2 26 4 Lobos St 1 2 1 1   10/05/2017 03:13:00 PM 3     5996833.19651 2088697.5304900003 37.7149843051513 -122.452860296276 (37.7149843051513, -122.452860296276)
4026 216034 2 26 8 Lobos St 1 2 1 1   10/05/2017 03:11:00 PM 3     5996778.28459 2088695.06883 37.714974399131705 -122.45304991653099 (37.7149743991317, -122.453049916531)
4030 216055 2 12 52 Lobos St 3 2 1 1   10/05/2017 02:49:00 PM 3     5996381.618969999 2088696.9088599999 37.714956710372 -122.454421085891 (37.714956710372, -122.454421085891)
4061 252970 5 82 101X Whipple Ave 2 2 1 1   10/05/2017 12:21:00 PM 3              
4071 251734 2 49 856 Prague St 3 2 1 1   10/05/2017 08:08:00 AM 3 Width 6ft   6002039.2106099995 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839)
4083 181036 2 13 170 Rolph St 2 2 1 1   10/05/2017 04:16:00 PM 3 Width 4ft   6000944.46471 2088397.62402 37.7143955675655 -122.438628565353 (37.7143955675655, -122.438628565353)
4092 216045 2 12 36 Lobos St 2 2 1 1   10/05/2017 03:04:00 PM 3     5996513.0629 2088696.2251900001 37.7149623706927 -122.45396671331999 (37.7149623706927, -122.45396671332)
4096 181028 2 48 95 Rolph St 2 2 1 1   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.4676599998 37.715132307492794 -122.44007027934201 (37.7151323074928, -122.440070279342)
4097 216058 2 12 58 Lobos St 1 2 1 1   10/05/2017 02:35:00 PM 3     5996320.31527 2088710.5585599998 37.7149906732676 -122.45463396169599 (37.7149906732676, -122.454633961696)
4103 216046 2 12 38 Lobos St 1 2 1 1   10/05/2017 03:02:00 PM 3     5996487.74032 2088710.41168 37.7149998715299 -122.454055262356 (37.7149998715299, -122.454055262356)
4113 181027 2 48 95 Rolph St 1 2 1 1   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.2481099998 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188)
4117 216048 2 12 40 Lobos St 1 2 1 1   10/05/2017 02:58:00 PM 3     5996463.1782599995 2088711.43982 37.7150012861457 -122.45414023299999 (37.7150012861457, -122.454140233)
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)
4144 216652 2 49 329 Faxon Ave 1 2 1 1   10/06/2017 08:15:00 AM 3 Width 4ft   5994725.9247 2090785.7094700001 37.7205969659665 -122.460295076156 (37.7205969659665, -122.460295076156)
Powered by Datasette · Query took 20.725ms · Data source: data.sfgov.org