sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
113 183695 1 41 1341 42nd Ave 9 1 1 1     2 Width 0ft   5983048.7244 2105854.1384 37.7612921278024 -122.50177309900499 (37.7612921278024, -122.501773099005)
123 18916 3 41 2621 Sacramento St 1 1 1 2     14 6x5   6002236.03231 2115724.70658 37.7895026155894 -122.4361187581 (37.7895026155894, -122.4361187581)
175 17881 3 41 2205 Pine St 1 1 1 2     12 3X3   6003346.6048 2115178.7939 37.7880667103656 -122.432237297056 (37.7880667103656, -122.432237297056)
261 141359 2 41 1499X Hayes St 2 1 1 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
399 17856 3 41 2121 Pine St 1 1 1 2   04/21/2000 12:00:00 AM 10 3X3   6003596.6138 2115206.3541 37.7881565558045 -122.431374278321 (37.7881565558045, -122.431374278321)
464 18999 3 41 3039 Sacramento St 1 1 1 2     24 3x3   6000252.38525 2115449.79519 37.7886348840283 -122.442962190565 (37.7886348840283, -122.442962190565)
468 18829 1 41 1940 Sacramento St 1 1 1 1     12 4.5x4.5   6005473.09052 2116220.8866 37.791048376629 -122.42495419379601 (37.791048376629, -122.424954193796)
552 194122 2 41 963 Minna St 1 1 1 1     8 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
557 194124 2 41 963 Minna St 3 15 1 1     9 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
569 194126 2 41 963 Minna St 5 1 1 1     10 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
572 194125 2 41 963 Minna St 4 1 1 1     9 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
573 194127 2 41 963 Minna St 6 1 1 1     10 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
574 194128 2 41 963 Minna St 7 1 1 1     10 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
575 194123 2 41 963 Minna St 2 1 1 1     8 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
587 233050 2 41 3181 23rd St 4 1 1 1   04/12/2011 12:00:00 AM 3 Width 3ft   6007759.16475 2102654.84325 37.7539280965303 -122.416083280221 (37.7539280965303, -122.416083280221)
606 233049 2 41 3181 23rd St 1 1 1 1   04/12/2011 12:00:00 AM 3 Width 3ft   6007718.49924 2102654.70617 37.753925433618704 -122.416223901805 (37.7539254336187, -122.416223901805)
923 210740 2 41 146 Ramsell St 1 1 1 1     7 Width 3ft   5992981.0390099995 2088189.5314 37.7133679617255 -122.46613798048901 (37.7133679617255, -122.466137980489)
949 13070 3 41 630 Lombard St 1 1 1 2     22 3x3   6009332.6794 2120506.3975 37.803032589908106 -122.4119030734 (37.8030325899081, -122.4119030734)
1058 19026 1 41 3173 Sacramento St 1 1 1 1     15 3X3   5999643.72529 2115362.65802 37.78836090738071 -122.44506178917 (37.7883609073807, -122.44506178917)
1289 131895 3 41 3274 Sacramento St 1 1 1 2     16 Width 4ft   5999203.0 2115426.0 37.7885096634197 -122.446591180632 (37.7885096634197, -122.446591180632)
1294 6921 3 41 425 Fell St 1 1 1 2   06/09/2010 12:00:00 AM 3 3X3   6005385.421 2110602.3829 37.7756164008395 -122.424857632506 (37.7756164008395, -122.424857632506)
1301 245837 1 41 451 Fell St 6 1 1 1   06/24/1995 12:00:00 AM 3 Width 0ft   6005362.4532 2110596.2894 37.775598372260106 -122.424936650191 (37.7755983722601, -122.424936650191)
1557 251590 2 41 340x Vicente St 3 7 1 1       3x3   5991910.0 2097743.0 37.739537567792894 -122.47053520105601 (37.7395375677929, -122.470535201056)
1560 210622 2 41 1386 09th Ave 1 1 1 1   05/23/2017 12:00:00 AM 3 Width 2ft   5993364.80541 2106063.8087299997 37.762468389619606 -122.46610965904699 (37.7624683896196, -122.466109659047)
1571 19004 1 41 3080X Sacramento St 1 1 1 1     12 3X3   6000063.0 2115465.0 37.7886658330885 -122.44361852594999 (37.7886658330885, -122.44361852595)
1656 9731 3 41 641 Gough St 1 1 1 2     2 4x4   6005777.9079 2111995.4394 37.7794635560295 -122.42359898745899 (37.7794635560295, -122.423598987459)
1693 251659 6 41 1050 North Point St 3 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1702 251658 6 41 1050 North Point St 2 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1717 251661 6 41 3200X Van Ness Ave 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1745 17972 3 41 2515 Pine St 3 1 1 2     12 3x3   6001748.1253 2114954.2725 37.7873594702652 -122.437751658759 (37.7873594702652, -122.437751658759)
1778 17971 3 41 2515 Pine St 2 1 1 2     12 3x3   6001715.6676 2114951.5677 37.7873501979521 -122.437863761621 (37.7873501979521, -122.437863761621)
1926 11155 3 41 2615 Hyde St 1 1 1 2     30 3X3   6006917.28019 2121296.80497 37.805067041968 -122.420317765078 (37.805067041968, -122.420317765078)
1980 11144 1 41 2553X Hyde St 2 1 1 13     36 3X3   6006934.8566 2121129.59308 37.8046089111446 -122.42024506476801 (37.8046089111446, -122.420245064768)
2001 141165 1 41 1901 O'Farrell St 1 1 1 1   02/28/2006 12:00:00 AM 1 Width 0ft   6002136.302999999 2113271.8343 37.7827619879541 -122.436288194942 (37.7827619879541, -122.436288194942)
2198 252932 2 41 66 Edgar Ave   1 1 1       3x3   5997141.0 2091179.0 37.7218154760893 -122.451975324711 (37.7218154760893, -122.451975324711)
2199 252934 2 41 78 Edgar Ave   1 1 1       3x3   5997141.0 2091229.0 37.7219527643602 -122.451978930217 (37.7219527643602, -122.451978930217)
2201 252933 2 41 72 Edgar Ave   1 1 1       3x3   5997141.0 2091205.0 37.7218868659906 -122.45197719957199 (37.7218868659906, -122.451977199572)
2237 17958 3 41 2500 Pine St 2 1 1 2   05/21/1992 12:00:00 AM 6 3x3   6001912.0842 2115029.0126 37.7875740088989 -122.437189749529 (37.7875740088989, -122.437189749529)
2596 253141 2 41 40 Brady St 6 1 1 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
2597 253140 2 41 40 Brady St 5 1 1 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
2601 8737 1 41 3250 Geary Blvd 1 1 1 1     6 3X3   5997009.0435 2113012.7724 37.781758017625705 -122.454007533534 (37.7817580176257, -122.454007533534)
2602 253139 2 41 40 Brady St 4 1 1 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
2604 253137 2 41 40 Brady St 2 1 1 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
2605 253138 2 41 40 Brady St 3 1 1 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
2619 139012 2 41 2569 SUTTER ST 1 1 1 1     0 Width 0ft   6000213.2565 2114045.1151 37.7847757661737 -122.442996653485 (37.7847757661737, -122.442996653485)
2684 233816 2 41 41 Brady St 3 1 1 1     9 Width 3ft   6006595.43726 2109656.08938 37.7730863765667 -122.420604692871 (37.7730863765667, -122.420604692871)
2792 17890 1 41 2237 Pine St 1 1 1 1     12 3X3   6003209.8546 2115154.5824 37.7879924771756 -122.432708698198 (37.7879924771756, -122.432708698198)
2894 17961 1 41 2501 Pine St 2 1 1 1     12 3x3   6001809.5629 2114963.9325 37.7873894873509 -122.437539789894 (37.7873894873509, -122.437539789894)
2931 93638 1 41 1603 Grove St 3 1 1 1     6 2x2   6000053.4052 2110559.6245 37.7751963877973 -122.44329925092501 (37.7751963877973, -122.443299250925)
2990 11143 1 41 2553X Hyde St 1 1 1 13     36 3X3   6006932.12852 2121148.49105 37.804660646434996 -122.42025584765301 (37.804660646435, -122.420255847653)
3109 19037 3 41 3235 Sacramento St 1 1 1 2     12 3X3   5999309.28069 2115314.23141 37.788208846394895 -122.446215424205 (37.7882088463949, -122.446215424205)
3162 11135 3 41 2454 Hyde St 2 1 1 2     45 3X3   6007038.94291 2120769.9344599997 37.8036272444521 -122.41985932665199 (37.8036272444521, -122.419859326652)
3402 253446 1 41 1339 Pierce St 1 1 1 1   02/21/1992 12:00:00 AM   3x3   6002186.0 2113207.0 37.7825867929513 -122.43611162356399 (37.7825867929513, -122.436111623564)
3422 17740 1 41 1347 Pierce St 1 1 1 8   12/04/1982 12:00:00 AM 6 3X3   6002203.7996 2113272.0173 37.7827663252153 -122.436054698673 (37.7827663252153, -122.436054698673)
3427 11134 3 41 2454 Hyde St 1 1 1 2     45 3X3   6007041.13953 2120754.1462 37.8035840176492 -122.41985060413299 (37.8035840176492, -122.419850604133)
3468 18831 3 41 2001 Sacramento St 1 1 1 2     12 3X3   6005118.6821099995 2116122.7244599997 37.79075882281 -122.426173443361 (37.79075882281, -122.426173443361)
3589 11167 1 41 2655 Hyde St 3 1 1 1     13 3X3   6006899.01173 2121433.76541 37.805442070952 -122.42039071266501 (37.805442070952, -122.420390712665)
3640 9732 3 41 645 Gough St 1 1 1 2   06/14/2011 12:00:00 AM 3 4x4   6005775.5462 2112013.5463 37.7795131398465 -122.423608445305 (37.7795131398465, -122.423608445305)
3680 9726 3 41 621 Gough St 2 1 1 2     12 4x4   6005799.3606 2111864.1645 37.779104318085295 -122.42351543791099 (37.7791043180853, -122.423515437911)
3750 253551 3 41 1000 Cayuga Ave 19 13 1 2   09/22/2017 04:40:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3758 253548 3 41 1000 Cayuga Ave 16 13 1 2   09/22/2017 04:31:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3837 253550 3 41 1000 Cayuga Ave 18 13 1 2   09/27/2017 11:43:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3840 253546 3 41 1000 Cayuga Ave 14 13 1 2   09/27/2017 11:50:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3841 253549 3 41 1000 Cayuga Ave 17 13 1 2   09/27/2017 11:46:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3842 253547 3 41 1000 Cayuga Ave 15 13 1 2   09/27/2017 11:40:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
4341 13314 3 41 3179X Sacramento St 1 1 1 2     18 3X3   5999566.13783 2115354.5120599996 37.7883341120707 -122.445329642351 (37.7883341120707, -122.445329642351)
4559 132044 3 41 444 Washington St 1 1 1 2   05/16/2002 12:00:00 AM 7 Width 4ft   6012372.27446 2117831.7295 37.795858655114 -122.401196364438 (37.795858655114, -122.401196364438)
4698 253662 2 41 715 Buena Vista Ave 2 1 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4701 253665 2 41 715 Buena Vista Ave 3 5 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4707 253664 2 41 715 Buena Vista Ave 2 5 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4708 253663 2 41 715 Buena Vista Ave 1 5 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4710 253661 2 41 715 Buena Vista Ave 1 1 1 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4781 244068 2 41 414 Clayton St 1 1 1 1     15 Width 0ft   5998440.5999 2109109.2833 37.771122022546294 -122.448773795857 (37.7711220225463, -122.448773795857)
4914 6236 3 41 1250 Ellis St 4 1 1 2   04/12/1995 12:00:00 AM 12 3X3   6004877.1927 2113359.8717 37.78315906739 -122.42681214119499 (37.78315906739, -122.426812141195)
4949 83043 5 41 100X Cargo Way 9 1 1 9   03/18/2017 02:49:00 PM 3     6018760.2720099995 2097656.0724299997 37.7408148829885 -122.377691543139 (37.7408148829885, -122.377691543139)
4990 3550 3 41 201X Cargo Way 60 1 1 2   03/16/1990 12:00:00 AM 6 3X3   6018708.52549 2097590.55589 37.7406321362531 -122.377865918974 (37.7406321362531, -122.377865918974)
4996 7951 1 41 1740 Franklin St 1 1 1 1   07/04/2010 12:00:00 AM 12 3X3   6005752.06301 2116078.7697900003 37.790673913324795 -122.42397884754801 (37.7906739133248, -122.423978847548)
5042 13051 1 41 548 Lombard St 1 1 1 1   01/21/2016 12:01:00 PM 3 3x3   6009711.5863 2120552.0553 37.803179205163005 -122.410595078527 (37.803179205163, -122.410595078527)
5264 17885 3 41 2214 Pine St 1 1 1 2     12 3X3   6003222.3202 2115211.247 37.788148770729705 -122.43266961876499 (37.7881487707297, -122.432669618765)
5320 19014 3 41 3122 Sacramento St 1 1 1 2     4 3X3   5999831.14019 2115437.85116 37.788578063082106 -122.44441877212401 (37.7885780630821, -122.444418772124)
5329 19019 1 41 3150 Sacramento St 3 1 1 14     18 3X3   5999711.09845 2115422.68298 37.788529565338 -122.444833006162 (37.788529565338, -122.444833006162)
5347 18998 3 41 3009 Sacramento St 1 1 1 2   07/01/2011 12:00:00 AM 3 3x3   6000320.39642 2115456.92187 37.788658329372396 -122.442727394678 (37.7886583293724, -122.442727394678)
5357 18911 1 41 2608 Sacramento St 1 1 1 1     12 3X3   6002198.68531 2115767.74163 37.7896186569185 -122.436251055535 (37.7896186569185, -122.436251055535)
5418 19000 3 41 3042 Sacramento St 1 1 1 2     12 4X4   6000225.4751699995 2115493.68766 37.7887538670327 -122.44305844861401 (37.7887538670327, -122.443058448614)
5480 87732 3 41 3200X Van Ness Ave 4 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005468.85489 2121438.02655 37.8053730758726 -122.425340270033 (37.8053730758726, -122.425340270033)
5487 17190 1 41 1804X Bush St 1 1 1 1     5 4X4   6004839.2103 2115093.1205 37.7879159889562 -122.427067036821 (37.7879159889562, -122.427067036821)
5539 17884 3 41 2210 Pine St 1 1 1 2     18 3X3   6003260.8806 2115214.139 37.7881588981801 -122.43253641314399 (37.7881588981801, -122.432536413144)
5572 19043 1 41 3277 Sacramento St 1 1 1 1     12 3X3   5999143.513780001 2115295.23483 37.788147218565996 -122.44678758008499 (37.788147218566, -122.446787580085)
5647 19035 1 41 3227 Sacramento St 1 1 1 1     12 3x3   5999339.77887 2115319.94044 37.7882262635735 -122.446110316852 (37.7882262635735, -122.446110316852)
5703 9727 3 41 621 Gough St 3 1 1 2     12 4x4   6005801.3288 2111846.4513 37.779055793051 -122.423507369454 (37.779055793051, -122.423507369454)
5831 18814 3 41 1921 Sacramento St 1 1 1 2     12 3X3   6005353.8734800005 2116157.5446599997 37.7908677208195 -122.42536217123501 (37.7908677208195, -122.425362171235)
5839 9898 3 41 1800X Pine St 4 1 1 2     6 3X3   6004962.1152 2115451.6483 37.788907365673204 -122.42666734903999 (37.7889073656732, -122.42666734904)
5862 9730 1 41 637 Gough St 1 1 1 1     12 4x4   6005783.8123 2111973.7899 37.779404445065396 -122.42357702198099 (37.7794044450654, -122.423577021981)
5864 17800 3 41 1855 Pine St 1 1 1 2     8 3x3   6005059.342 2115410.1523 37.788798924352996 -122.42632800170901 (37.788798924353, -122.426328001709)
5875 19016 1 41 3147 Sacramento St 1 1 1 1     12 3X3   5999737.62232 2115377.53995 37.7884071280271 -122.444737991858 (37.7884071280271, -122.444737991858)
5888 11169 3 41 2700 Hyde St 1 1 1 2     36 3X3   6006924.13035 2121583.86925 37.8058556331999 -122.420314446577 (37.8058556331999, -122.420314446577)
5914 18827 3 41 1911 Sacramento St 1 1 1 2     12 3X3   6005492.837780001 2116179.1366 37.7909348570073 -122.424882897351 (37.7909348570073, -122.424882897351)
5944 96090 3 41 3122 Sacramento St 2 1 1 2   06/04/2011 12:00:00 AM 3 3x3   5999797.96737 2115433.02091 37.7885629076984 -122.444533197372 (37.7885629076984, -122.444533197372)
5961 18819 3 41 1850 Sacramento St 1 1 1 2     12 3X3   6005893.34484 2116280.69836 37.7912363340264 -122.423504381436 (37.7912363340264, -122.423504381436)
5990 17787 1 41 1805 Pine St 2 1 1 1   12/09/1997 12:00:00 AM 8 3x3   6005226.8193 2115439.913 37.788890105137604 -122.425750672593 (37.7888901051376, -122.425750672593)
6026 13056 3 41 567 Lombard St 1 1 1 2   01/06/2016 07:33:00 AM 3 3X3   6009638.2249 2120505.3867 37.8030469515764 -122.410845650802 (37.8030469515764, -122.410845650802)
Powered by Datasette · Query took 20.314ms · Data source: data.sfgov.org