sf-trees

Data source: data.sfgov.org

Custom SQL query returning 54 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4779 188471 2 97 255 12th St 5 1 1 1     15 Width 5ft   6008055.90153 2108933.51614 37.7711845613454 -122.41550157982799 (37.7711845613454, -122.415501579828)
9221 16483 1 97 220 Newhall St 5 1 1 1     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.38421892893899 (37.7425024549748, -122.384218928939)
11951 19967 3 97 100 STAIRWAY41 5 1 1 2     6 25ST            
13486 2517 3 97 1555 Burke Ave 5 1 1 2     12 3X3   6016481.64243 2098901.45238 37.7441086284068 -122.385657039951 (37.7441086284068, -122.385657039951)
14244 2501 3 97 1500 Burke Ave 5 1 1 2     12 3X3   6016709.08958 2098828.16093 37.7439199677279 -122.38486546568599 (37.7439199677279, -122.384865465686)
14293 17415 3 97 1820X Palou Ave 5 1 1 2     12 3x3   6013619.40586 2096223.80848 37.73659758599771 -122.395366549732 (37.7365975859977, -122.395366549732)
15374 16525 3 97 375 Newhall St 5 1 1 2     12 3X3   6016336.5971099995 2098251.27907 37.7423153586798 -122.38611326331801 (37.7423153586798, -122.386113263318)
23428 106029 1 97 180 Howard St 5 1 1 1   02/05/2015 12:00:00 AM 14 3x3 Permit Number 770222 6014636.89755 2115962.51686 37.790852311826704 -122.39322941879801 (37.7908523118267, -122.393229418798)
23831 126000 2 97 2510 Jones St 5 1 1 1     14 Width 4ft   6007902.73328 2121542.33791 37.805796693425705 -122.41692488738501 (37.8057966934257, -122.416924887385)
25271 125991 2 97 2361 Taylor St 5 1 1 1     11 Width 3ft   6008338.82398 2121554.9566599997 37.805855861614795 -122.41541661910699 (37.8058558616148, -122.415416619107)
27151 189948 2 97 162 Spear St 5 1 1 1     5 Width 1ft   6014781.223780001 2116142.62721 37.79135487007321 -122.392742658052 (37.7913548700732, -122.392742658052)
27659 189891 2 97 200 Newhall St 5 4 1 1     4 Width 3ft   6016826.79146 2098321.83879 37.7425362195639 -122.384423217764 (37.7425362195639, -122.384423217764)
39389 189870 2 97 401 Newhall St 5 4 1 1     13 Width 3ft   6016138.74056 2097991.9117 37.741592236291396 -122.386779313807 (37.7415922362914, -122.386779313807)
44285 206008 2 97 600 Vicente St 5 1 1 1     6 Width 3ft   5990990.06403 2097739.22497 37.7394739659536 -122.47371563298701 (37.7394739659536, -122.473715632987)
49114 103343 2 97 590X 09th St 5 1 1 1     9 3x3   6010323.0 2108639.0 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146)
52501 125984 2 97 2362 Taylor St 5 1 1 1     18 Width 6ft   6008373.73288 2121637.11508 37.8060834098955 -122.41530163086 (37.8060834098955, -122.41530163086)
53751 138243 2 97 1509 Lyon St 5 1 1 1     17 Width 0ft   5999648.5931 2114056.0979 37.7847737117432 -122.44495098624701 (37.7847737117432, -122.444950986247)
61818 142100 2 97 904 Fell St 5 1 1 1     12 Width 0ft   6002972.7027 2110318.8393 37.7747012881718 -122.43318354410201 (37.7747012881718, -122.433183544102)
74030 189936 2 97 28 Fremont St 5 1 1 1     6 Width 5ft   6013261.48411 2116177.8977900003 37.7913671907995 -122.398003434816 (37.7913671907995, -122.398003434816)
74466 189898 2 97 220 Newhall St 5 4 1 1     10 Width 3ft   6016641.64949 2098357.6793299997 37.7426243909147 -122.385065886799 (37.7426243909147, -122.385065886799)
74473 189880 2 97 325 Newhall St 5 4 1 1     7 Width 3ft   6016536.79452 2098327.4391099997 37.742535556771 -122.385426341355 (37.742535556771, -122.385426341355)
78541 14928 3 97 320X Newhall St 5 1 1 2     3 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
79162 20965 3 97 2002X Sunset Blvd 5 1 1 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
81810 50386 1 97 296 Liberty St 5 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532583998 37.75737018369129 -122.427864268021 (37.7573701836913, -122.427864268021)
84776 6848 1 97 595X Newhall St 5 1 1 1     12 3x3   6015895.1615953 2097662.6258274 37.740674595672296 -122.387598567026 (37.7406745956723, -122.387598567026)
85060 102876 1 97 2761 21st St 5 1 1 1       3x3   6009574.6 2103896.5 37.757439313651396 -122.409892695521 (37.7574393136514, -122.409892695521)
88163 21790 1 97 2585 Taylor St 5 1 1 1     9 4X4   6008342.51156 2121554.8602 37.8058558040212 -122.41540385079901 (37.8058558040212, -122.415403850799)
89283 16514 3 97 330 Newhall St 5 1 1 2     6 3x3   6016343.322430001 2098341.01182 37.7425621187056 -122.386096262995 (37.7425621187056, -122.386096262995)
90964 16503 3 97 325 Newhall St 5 1 1 2     12 3X3   6016450.0254075 2098336.1941648996 37.742554795386894 -122.385726976255 (37.7425547953869, -122.385726976255)
98613 106036 1 97 195X Main St 5 1 1 1   02/05/2015 12:00:00 AM   3x3 Permit Number 770222 6014366.747719999 2116104.57878 37.7912273690908 -122.394174082061 (37.7912273690908, -122.394174082061)
101673 119745 2 97 15X Fremont St 5 1 1 1       3x3   6013411.0 2116073.0 37.7910874921548 -122.39747874956998 (37.7910874921548, -122.39747874957)
113571 22889 1 97 95X Valencia St 5 1 1 1     30 3X3   6006042.93395 2109155.55847 37.771680885423606 -122.422480302267 (37.7716808854236, -122.422480302267)
113999 14911 3 97 110X Newhall St 5 1 1 2     6 3x3   6017284.29114 2098190.72199 37.7422014869413 -122.38283218039 (37.7422014869413, -122.38283218039)
119053 6649 3 97 495X Newhall St 5 1 1 2     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472)
120916 101045 1 97 655 Beach St 5 1 1 1         Permit Number 47845 6006837.0 2121873.0 37.8066446021589 -122.42063651284501 (37.8066446021589, -122.420636512845)
122587 97183 2 97 10X Fremont St 5 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
126122 20125 1 97 924X Fell St 5 1 1 1     18 3X3   6002999.41967 2110319.2516799998 37.7747039360019 -122.433091154251 (37.7747039360019, -122.433091154251)
127149 2509 3 97 1501 Burke Ave 5 1 1 2     6 3X3   6016682.7889975 2098765.8378067003 37.743747386445996 -122.384952066789 (37.743747386446, -122.384952066789)
132834 189962 2 97 562 09th St 5 1 1 1     8 Width 3ft   6010439.90597 2108494.60457 37.7701131234445 -122.407224232334 (37.7701131234445, -122.407224232334)
135731 115846 2 97 1500 Bay St 5 1 1 1     12 3x3   6003504.2747 2120736.26354 37.8033350304463 -122.432088807873 (37.8033350304463, -122.432088807873)
140383 16554 3 97 500X Newhall St 5 1 1 2     12 3x3   6016006.287148001 2097894.9109735 37.74131855784729 -122.387230532448 (37.7413185578473, -122.387230532448)
143020 4916 3 97 195X Newhall St 5 1 1 2   01/26/2015 05:46:00 AM 3 3X3   6017015.097207401 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687)
149692 222908 2 97 363 Page St 5 1 1 1     5 Width 4ft   6004803.104169999 2109829.19919 37.773460518813 -122.426816934368 (37.773460518813, -122.426816934368)
151213 115850 2 97 3501 Laguna St 5 1 1 1     7 3x3   6003589.56269 2120774.48991 37.8034448250715 -122.431796396884 (37.8034448250715, -122.431796396884)
153716 93113 1 97 300 Newhall St 5 1 1 1   02/02/2010 12:00:00 AM 9 3x3 Permit Number 53024 6016543.92232 2098378.4931799998 37.7426761351889 -122.385405252254 (37.7426761351889, -122.385405252254)
156358 188485 2 97 1525 Burke Ave 5 1 1 1     5 Width 3ft   6016660.6215 2098754.7402 37.7437156885266 -122.385027944407 (37.7437156885266, -122.385027944407)
157632 119739 1 97 45 Fremont St 5 1 1 1     8     6013469.82728 2116055.87494 37.7910437460335 -122.397274006392 (37.7910437460335, -122.397274006392)
157640 189843 2 97 101 Newhall St 5 4 1 1     1 Width 3ft   6017155.58292 2098191.33075 37.742196046505 -122.38327726024599 (37.742196046505, -122.383277260246)
158918 189855 2 97 102 Newhall St 5 4 1 1     9 Width 3ft   6017245.40272 2098209.38961 37.7422505957884 -122.382967944715 (37.7422505957884, -122.382967944715)
161429 189951 2 97 120 Howard St 5 1 1 1     8 Width 1ft   6014728.34644 2116051.81938 37.791102595846894 -122.39291925791099 (37.7911025958469, -122.392919257911)
171108 206012 2 97 650 Vicente St 5 1 1 1     6 Width 3ft   5990870.16608 2097736.47672 37.739459475161794 -122.474129983014 (37.7394594751618, -122.474129983014)
180715 189930 2 97 43 Fremont St 5 1 1 1     7 Width 5ft   6013282.15015 2116252.99602 37.7915745438725 -122.39793720064199 (37.7915745438725, -122.397937200642)
181328 189963 2 97 1000 Brannan St 5 1 1 1     14 Width 3ft   6010349.36768 2108372.96344 37.7697740574441 -122.40752882731 (37.7697740574441, -122.40752882731)
182201 125976 2 97 633 Beach St 5 1 1 1     5 Width 3ft   6007074.37921 2121877.42075 37.8066701158897 -122.419815329109 (37.8066701158897, -122.419815329109)
Powered by Datasette · Query took 5.112ms · Data source: data.sfgov.org