sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
973 248014 3 124 525 Franconia St 5 1 1 2     7 Width 4ft   6009926.50706 2098096.5279599996 37.7415335869952 -122.40826658702801 (37.7415335869952, -122.408266587028)
1791 251711 3 124 902 Market St 3 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1793 251713 3 124 902 Market St 5 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1795 251712 3 124 902 Market St 4 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1797 251710 3 124 902 Market St 2 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1799 251715 3 124 902 Market St 7 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1805 251709 3 124 902 Market St 1 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1807 251714 3 124 902 Market St 6 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
18807 4403 3 124 1044 Church St 1 1 1 2     12 3x3   6004378.89078 2102815.5899099996 37.754178832009295 -122.42778451855101 (37.7541788320093, -122.427784518551)
19699 113640 6 124 545X Minna St 1 5 1 1           6010081.18772 2112137.85468 37.7800965567953 -122.40872210131901 (37.7800965567953, -122.408722101319)
24554 197424 2 124 1200 04th St 5 1 1 1     5 Width 5ft   6015005.7210099995 2109404.95283 37.77286720818179 -122.39149465358 (37.7728672081818, -122.39149465358)
25675 240946 2 124 192 Laidley St 3 1 1 1     7 Width 2ft   6004126.6518 2097259.6464 37.7389092249709 -122.42826087863199 (37.7389092249709, -122.428260878632)
25742 240895 2 124 1201 Treat Ave 9 1 1 1     8 Width 4ft   6008713.19989 2101208.21335 37.7500095705047 -122.41268172948999 (37.7500095705047, -122.41268172949)
26063 197421 2 124 1200 04th St 2 1 1 1     5 Width 5ft   6015000.4324199995 2109495.8046 37.7731163734468 -122.391519300385 (37.7731163734468, -122.391519300385)
26382 197390 2 124 1350 04th St 8 1 1 1     5 Width 5ft   6015085.78148 2108970.82178 37.771679623744895 -122.39118736151 (37.7716796237449, -122.39118736151)
27001 240920 2 124 83 Bemis St 1 1 1 1     2 Width 3ft   6003674.035680001 2096782.4089099998 37.7375732191201 -122.42979178467199 (37.7375732191201, -122.429791784672)
27075 136353 2 124 1508 Green St 1 1 1 1     7 Width 3ft   6005781.66694 2118620.21558 37.7976537549681 -122.424057229776 (37.7976537549681, -122.424057229776)
27380 240911 2 124 1051 Florida St 1 1 1 1     10 Width 4ft   6009458.354780001 2103057.57846 37.755129308388796 -122.410235489878 (37.7551293083888, -122.410235489878)
27443 136362 2 124 1715 Taylor St 2 2 1 1     6 Width 3ft   6008714.5466 2118843.19382 37.7984311487376 -122.413924418086 (37.7984311487376, -122.413924418086)
29594 136360 2 124 1725 Taylor St 14 1 1 1     2 Width 2ft   6008711.32926 2118885.42513 37.7985469247543 -122.41393854015499 (37.7985469247543, -122.413938540155)
29651 240512 2 124 301 Florida St 2 1 1 1     6 Width 3ft   6009219.21952 2106751.79124 37.7652593690624 -122.41132345193998 (37.7652593690624, -122.41132345194)
29703 197375 2 124 300 San Bruno Ave 9 1 1 1     5 Width 3ft   6010873.43891 2106555.26332 37.7648123871029 -122.405588027383 (37.7648123871029, -122.405588027383)
30840 248013 2 124 525 Franconia St 4 1 1 1     7 Width 4ft   6009922.12667 2098078.01565 37.741482510922395 -122.408280427599 (37.7414825109224, -122.408280427599)
31301 136352 2 124 301 Euclid Ave 5 9 1 1     6 Width 4ft   5997962.800430001 2113889.01187 37.7842185814711 -122.450771195452 (37.7842185814711, -122.450771195452)
31538 197428 2 124 1200 04th St 9 1 1 1     4 Width 5ft   6015013.65902 2109278.1968400003 37.7725196049206 -122.39145833173 (37.7725196049206, -122.39145833173)
32059 240896 2 124 1201 Treat Ave 11 1 1 1     9 Width 4ft   6008710.779680001 2101249.00025 37.7501214263764 -122.41269298178999 (37.7501214263764, -122.41269298179)
33768 46508 1 124 675 Minna St 2 1 1 1   03/27/2002 12:00:00 AM 5   Permit Number 44677 6009091.30835 2111167.9463 37.777377926079 -122.412077991228 (37.777377926079, -122.412077991228)
35818 248016 2 124 525 Franconia St 7 2 1 1     8 Width 6ft   6009938.8027 2098138.8555900003 37.7416504979844 -122.408227057349 (37.7416504979844, -122.408227057349)
36656 136354 2 124 1508 Green St 2 1 1 1     7 Width 3ft   6005758.24578 2118617.72057 37.79764558194071 -122.42413809590401 (37.7976455819407, -122.424138095904)
36929 197417 2 124 1110 04th St 6 1 1 1     5 Width 5ft   6014986.84616 2109711.37392 37.7737075248119 -122.391581371605 (37.7737075248119, -122.391581371605)
36973 197446 2 124 577 Nelson Rising Ln 5 1 1 1     4 Width 5ft   6013697.348569999 2108075.95156 37.7691453611896 -122.39592735257798 (37.7691453611896, -122.395927352578)
37373 36876 1 124 2400 Divisadero St 4 1 1 1 1 05/26/1998 12:00:00 AM 6   Permit Number 39539 6000808.4477 2116625.0074 37.791893398513395 -122.44112265160601 (37.7918933985134, -122.441122651606)
37840 197380 2 124 2251 Silver Ave 2 4 1 1     11 Width 3ft   6012873.308019999 2096314.08493 37.7368039417418 -122.39795247834299 (37.7368039417418, -122.397952478343)
37953 197420 2 124 1200 04th St 1 1 1 1     5 Width 5ft   6014998.578369999 2109523.60508 37.773192604486105 -122.391527657797 (37.7731926044861, -122.391527657797)
38124 197384 2 124 1350 04th St 2 1 1 1     4 Width 5ft   6015096.00206 2108800.56286 37.7712126975445 -122.391140104833 (37.7712126975445, -122.391140104833)
39414 119522 2 124 790 31st Ave 1 9 1 1     5 Width 3ft   5986359.69309 2110558.27509 37.7744022999761 -122.490668135755 (37.7744022999761, -122.490668135755)
39658 197389 2 124 1350 04th St 7 1 1 1     4 Width 5ft   6015087.5689199995 2108946.60059 37.771613216903894 -122.39117948526001 (37.7716132169039, -122.39117948526)
41777 240887 2 124 3009 26th St 2 1 1 1     2 Width 5ft   6009470.6055 2100993.60175 37.7494627754843 -122.41004742097601 (37.7494627754843, -122.410047420976)
42363 240915 2 124 315 Lexington St 3 1 1 1     1 Width 3ft   6006533.583380001 2104305.2413 37.7583907231708 -122.420438775123 (37.7583907231708, -122.420438775123)
43111 197438 2 124 1300 04th St 5 1 1 1     4 Width 5ft   6015034.670969999 2108883.60182 37.7714373005145 -122.391358059129 (37.7714373005145, -122.391358059129)
43994 136359 2 124 1725 Taylor St 13 1 1 1     6 Width 2ft   6008708.52224 2118897.8442599997 37.7985808669576 -122.413949132363 (37.7985808669576, -122.413949132363)
44403 197400 2 124 1155 04th St 1 1 1 1     5 Width 5ft   6015059.961759999 2109443.9934900003 37.7729774155998 -122.391309756557 (37.7729774155998, -122.391309756557)
44420 197457 2 124 668 Natoma St 15 1 1 1     4 Width 2ft   6009096.316000001 2110957.37076 37.77680001633121 -122.412045782913 (37.7768000163312, -122.412045782913)
44992 240941 2 124 671 Church St 53 7 1 1     5 Width 3ft   6004292.854119999 2105210.6370599996 37.760750197983896 -122.4282527371 (37.7607501979839, -122.4282527371)
45338 240929 2 124 147 Park St 1 1 1 1     6 Width 3ft   6005793.48345 2096408.78374 37.7366671197906 -122.42243729804399 (37.7366671197906, -122.422437298044)
45643 197407 2 124 1101 04th St 2 1 1 1     3 Width 5ft   6015042.44961 2109744.00575 37.7738002107574 -122.39139131066999 (37.7738002107574, -122.39139131067)
46280 197411 2 124 1101 04th St 6 1 1 1     5 Width 5ft   6015024.81769 2109879.0365400002 37.774169996686 -122.391461744659 (37.774169996686, -122.391461744659)
47169 38986 1 124 300x San Bruno Ave 8 1 1 1   11/17/1998 12:00:00 AM 5 3x3 Permit Number 40762 6010873.0726 2106579.5754400003 37.764879122199 -122.405591006845 (37.764879122199, -122.405591006845)
48334 197414 2 124 1110 04th St 3 1 1 1     6 Width 5ft   6014981.739440001 2109803.00942 37.7739588520651 -122.391605444662 (37.7739588520651, -122.391605444662)
48402 240890 2 124 1201 Treat Ave 3 1 1 1     9 Width 4ft   6008720.4908300005 2101064.55739 37.749615532544 -122.412646362752 (37.749615532544, -122.412646362752)
48807 240912 2 124 85 Sycamore St 1 1 1 1     5 Width 3ft   6006337.237319999 2105831.0184 37.7625690840066 -122.421226172049 (37.7625690840066, -122.421226172049)
50197 240889 2 124 1201 Treat Ave 2 1 1 1     7 Width 4ft   6008721.46882 2101044.16868 37.7495596045891 -122.41264153966999 (37.7495596045891, -122.41264153967)
51110 197419 2 124 1110 04th St 8 1 1 1     5 Width 5ft   6014990.758169999 2109661.0531900004 37.7735695724098 -122.39156432044399 (37.7735695724098, -122.391564320444)
52247 240888 2 124 1201 Treat Ave 1 1 1 1     10 Width 4ft   6008723.38535 2101024.2236 37.7495049474174 -122.41263350244199 (37.7495049474174, -122.412633502442)
53759 136355 2 124 1639 Beach St 1 1 1 1     9 Width 4ft   6002367.638040001 2121224.4246 37.8046108851334 -122.436057126653 (37.8046108851334, -122.436057126653)
53894 36877 1 124 2400 Divisadero St 2 1 1 1 1 05/26/1998 12:00:00 AM 7   Permit Number 39539 6000814.63294 2116594.68212 37.7918104855159 -122.441099074089 (37.7918104855159, -122.441099074089)
54022 197440 2 124 1300 04th St 7 1 1 1     4 Width 5ft   6015037.520269999 2108824.47635 37.7712751131743 -122.391344069293 (37.7712751131743, -122.391344069293)
54799 240891 2 124 1201 Treat Ave 4 1 1 1     10 Width 4ft   6008718.64971 2101088.20431 37.7496803583719 -122.41265440088999 (37.7496803583719, -122.41265440089)
54834 96395 1 124 800 Tennessee St 5 1 1 1   05/17/2011 12:00:00 AM 7 3x3 Permit Number 767136 6015448.2444 2105163.7417200003 37.761246318881 -122.389667624156 (37.761246318881, -122.389667624156)
54852 240919 2 124 556 Laidley St 1 1 1 1     1 Width 3ft   6002989.394780001 2095969.72486 37.7353029813381 -122.432100892951 (37.7353029813381, -122.432100892951)
55562 197427 2 124 1200 04th St 8 1 1 1     5 Width 5ft   6015011.5330300005 2109302.8867 37.772587279805705 -122.39146741218599 (37.7725872798057, -122.391467412186)
55890 46507 1 124 675 Minna St 1 1 1 1   03/27/2002 12:00:00 AM 7   Permit Number 44677 6009082.35488 2111157.53331 37.7773488321059 -122.41210822822599 (37.7773488321059, -122.412108228226)
56966 197399 2 124 1255 04th St 8 1 1 1     5 Width 5ft   6015067.88959 2109305.99464 37.7725989413206 -122.39127268468201 (37.7725989413206, -122.391272684682)
57862 197386 2 124 1350 04th St 4 1 1 1     5 Width 5ft   6015093.74839 2108858.0484599997 37.7713704152436 -122.39115191923901 (37.7713704152436, -122.391151919239)
58442 197432 2 124 1200 04th St 13 1 1 1     4 Width 5ft   6015019.54428 2109161.1913 37.7721986602722 -122.39142979267599 (37.7721986602722, -122.391429792676)
58866 197423 2 124 1200 04th St 4 1 1 1     4 Width 5ft   6015003.8063199995 2109440.09446 37.77296359302979 -122.391503734027 (37.7729635930298, -122.391503734027)
59323 240918 2 124 4158 26th St 2 1 1 1     2 Width 4ft   6002863.78754 2100671.92533 37.748207011640794 -122.43287098151 (37.7482070116408, -122.43287098151)
59554 197455 2 124 668 Natoma St 12 1 1 1     4 Width 2ft   6009137.470430001 2110995.28328 37.7769064241241 -122.41190609659999 (37.7769064241241, -122.4119060966)
59927 197410 2 124 1101 04th St 5 1 1 1     5 Width 5ft   6015033.4092 2109848.12885 37.7740856078918 -122.39142986370301 (37.7740856078918, -122.391429863703)
61129 179418 2 124 416 Peninsula Ave 1 1 1 1     5 Width 2ft   6012204.41611 2086714.8275099997 37.710409062701395 -122.399591381259 (37.7104090627014, -122.399591381259)
61264 248011 2 124 525 Franconia St 2 9 1 1     7 Width 6ft   6009911.76805 2098028.06886 37.7413447878202 -122.408312722264 (37.7413447878202, -122.408312722264)
61382 240885 2 124 3013 26th St 1 1 1 1     1 Width 6ft   6009432.4377 2100992.16843 37.7494567005869 -122.410179305636 (37.7494567005869, -122.410179305636)
61868 197451 2 124 668 Natoma St 5 1 1 1     3 Width 2ft   6009234.5273400005 2111091.20385 37.77717524406629 -122.41157712459 (37.7771752440663, -122.41157712459)
62026 240905 2 124 1201 Treat Ave 21 1 1 1     10 Width 4ft   6008695.452190001 2101477.07086 37.750746796947396 -122.412762107295 (37.7507467969474, -122.412762107295)
62745 240901 2 124 1201 Treat Ave 17 1 1 1     10 Width 4ft   6008702.87271 2101385.26076 37.7504951234628 -122.41272995653601 (37.7504951234628, -122.412729956536)
63145 197385 2 124 1350 04th St 3 1 1 1     5 Width 5ft   6015094.6551 2108827.79856 37.7712874060154 -122.391146668097 (37.7712874060154, -122.391146668097)
63621 197397 2 124 1255 04th St 6 1 1 1     5 Width 5ft   6015070.62155 2109253.41262 37.7724547143562 -122.391259558193 (37.7724547143562, -122.391259558193)
63669 96392 1 124 800 Tennessee St 2 1 1 1   05/17/2011 12:00:00 AM 6 3x3 Permit Number 767136 6015444.53946 2105235.26093 37.761442489801105 -122.389685433429 (37.7614424898011, -122.389685433429)
63712 197401 2 124 1155 04th St 3 1 1 1     5 Width 5ft   6015056.142469999 2109498.92263 37.7731280268706 -122.391326808588 (37.7731280268706, -122.391326808588)
63747 197415 2 124 1110 04th St 4 1 1 1     5 Width 5ft   6014984.865540001 2109771.18409 37.77387164030579 -122.391592405366 (37.7738716403058, -122.391592405366)
63969 240940 2 124 671 Church St 52 7 1 1     6 Width 3ft   6004314.46376 2105211.05218 37.7607525605073 -122.428178028592 (37.7607525605073, -122.428178028592)
64024 240907 2 124 355 Park St 1 1 1 1     9 Width 2ft   6007123.31174 2096296.95431 37.736434989479896 -122.417831571267 (37.7364349894799, -122.417831571267)
64844 38496 1 124 1520 Green St 1 1 1 1 1 08/26/1998 12:00:00 AM 7   Permit Number 40490 6005695.28325 2118608.46159 37.797616603979996 -122.424355304657 (37.79761660398, -122.424355304657)
64881 240906 2 124 1201 Treat Ave 22 1 1 1     10 Width 4ft   6008696.38021 2101499.73493 37.7508090794957 -122.412760500211 (37.7508090794957, -122.412760500211)
65164 197405 2 124 1145 04th St 1 1 1 1     5 Width 5ft   6015047.0197 2109662.59609 37.7735769315563 -122.391369809678 (37.7735769315563, -122.391369809678)
65397 240931 2 124 4596 19th St 1 1 1 1     6 Width 3ft   6000667.48938 2104674.07897 37.7590711421385 -122.440752730779 (37.7590711421385, -122.440752730779)
66327 240908 2 124 725 Florida St 3 1 1 1     10 Width 4ft   6009319.31515 2104845.25039 37.76003005686479 -122.410842580843 (37.7600300568648, -122.410842580843)
66952 240514 2 124 457 14th St 1 1 1 1     12 Width 3ft   6005714.7802800005 2107820.47236 37.7679965411359 -122.423520473904 (37.7679965411359, -122.423520473904)
67125 197449 2 124 668 Natoma St 2 1 1 1     3 Width 2ft   6009262.53236 2111115.69015 37.777244048518206 -122.41148197633301 (37.7772440485182, -122.411481976333)
67184 197435 2 124 1300 04th St 2 1 1 1     4 Width 5ft   6015029.61492 2108966.93535 37.7716658353527 -122.391381374959 (37.7716658353527, -122.391381374959)
67549 240945 2 124 192 Laidley St 1 1 1 1     9 Width 3ft   6004100.4699 2097291.61636 37.738995525713 -122.428353681499 (37.738995525713, -122.428353681499)
67657 197442 2 124 1300 04th St 9 1 1 1     4 Width 5ft   6015041.42072 2108767.34362 37.7711184557895 -122.391326582849 (37.7711184557895, -122.391326582849)
67808 38390 1 124 2435 Polk St 2 1 1 1   08/17/1998 12:00:00 AM 5 3x5 Permit Number 40447 6006235.29717 2119188.7184099997 37.799240320944904 -122.42252796141399 (37.7992403209449, -122.422527961414)
67915 240938 2 124 671 Church St 50 7 1 1     6 Width 3ft   6004312.93129 2105220.54809 37.760778547308895 -122.428184005481 (37.7607785473089, -122.428184005481)
68386 240924 2 124 1200 Florida St 1 1 1 1     6 Width 3ft   6009473.34401 2102092.1266 37.752479233853705 -122.410115496035 (37.7524792338537, -122.410115496035)
68738 240927 2 124 1148 Shotwell St 1 1 1 1     10 Width 3ft   6008036.38125 2101261.79072 37.750118671749796 -122.415026003064 (37.7501186717498, -122.415026003064)
68933 240899 2 124 1201 Treat Ave 15 1 1 1     9 Width 4ft   6008706.04279 2101335.66338 37.750359118082706 -122.412715488225 (37.7503591180827, -122.412715488225)
71098 240926 2 124 1200 Florida St 3 1 1 1     7 Width 3ft   6009479.18585 2101981.64475 37.752176202776 -122.410087494765 (37.752176202776, -122.410087494765)
71315 240944 2 124 88 Whitney St 1 1 1 1     8 Width 3ft   6004279.64168 2097645.58275 37.7399775737156 -122.427759401399 (37.7399775737156, -122.427759401399)
72200 197422 2 124 1200 04th St 3 1 1 1     5 Width 5ft   6015001.02116 2109469.2789 37.7730435724386 -122.39151540903099 (37.7730435724386, -122.391515409031)
72353 96391 1 124 800 Tennessee St 1 1 1 1   05/17/2011 12:00:00 AM 6 3x3 Permit Number 767136 6015443.33438 2105260.58125 37.7615119471268 -122.389691369876 (37.7615119471268, -122.389691369876)
Powered by Datasette · Query took 2.24ms · Data source: data.sfgov.org