sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
16090 2536 3 97 1575 Burke Ave 4 1 1 2     6 3X3   6016262.668930001 2099065.69559 37.744547487686 -122.38642565812 (37.744547487686, -122.38642565812)
16099 16541 3 97 400X Newhall St 2 1 1 2     6 3x3   6016112.61616 2098044.40161 37.7417349164267 -122.386873303758 (37.7417349164267, -122.386873303758)
16103 17387 3 97 1657 Palou Ave 1 1 1 2     18 3x3   6014551.02447 2095461.0111900002 37.7345548713079 -122.39209219010901 (37.7345548713079, -122.392092190109)
16423 2503 3 97 1500 Burke Ave 7 1 1 2     12 3X3   6016672.43224 2098847.72364 37.743971655361705 -122.384993582204 (37.7439716553617, -122.384993582204)
16483 16521 3 97 375 Newhall St 1 1 1 2     12 3X3   6016284.3157 2098184.69928 37.742129650455205 -122.38628939735099 (37.7421296504552, -122.386289397351)
16723 2498 3 97 1500 Burke Ave 2 1 1 2     12 3X3   6016761.82696 2098799.8032400003 37.7438450200413 -122.384681135251 (37.7438450200413, -122.384681135251)
16790 16509 3 97 325 Newhall St 11 1 1 2   12/03/1992 12:00:00 AM 3 3X3   6016661.92107 2098301.48789 37.742471221974 -122.384991878867 (37.742471221974, -122.384991878867)
16852 16499 3 97 325 Newhall St 1 1 1 2     12 3X3   6016428.13466 2098327.93774 37.7425309135822 -122.385802093385 (37.7425309135822, -122.385802093385)
16898 2502 3 97 1500 Burke Ave 6 1 1 2     12 3X3   6016691.633780001 2098834.3481 37.743935990943996 -122.38492625536001 (37.743935990944, -122.38492625536)
16981 16634 3 97 158 Noe St 1 1 1 2     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.43340627149901 (37.7664480128774, -122.433406271499)
17478 5658 3 97 1349-1349 Dolores St 1 1 1 2     100 3X3   6005239.88286 2100530.07402 37.74795200168529 -122.42464442051 (37.7479520016853, -122.42464442051)
18731 5529 3 97 895 Dolores St 1 1 1 2     100 4X4   6005093.86648 2103161.8218799997 37.7551699235695 -122.425336590916 (37.7551699235695, -122.425336590916)
19409 16623 3 97 136 Noe St 1 1 1 2     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285)
20318 5479 3 97 695 Dolores St 1 1 1 2     20 8   6005031.79334 2104320.1538400003 37.758346924379 -122.42563369543801 (37.758346924379, -122.425633695438)
21055 5523 3 97 865 Dolores St 2 1 1 2     50 3X3   6005084.41522 2103351.40166 37.755689931362795 -122.425382766602 (37.7556899313628, -122.425382766602)
23044 16540 3 97 400X Newhall St 1 1 1 2     5 0   6016126.25571 2098060.8881 37.741780940152296 -122.386827291768 (37.7417809401523, -122.386827291768)
23049 14686 3 97 775 McAllister St 1 1 1 2     16 4X4   6005447.7824 2111997.5051 37.779450588232706 -122.424741179621 (37.7794505882327, -122.424741179621)
23084 16626 3 97 138 Noe St 1 1 1 2   02/02/2001 12:00:00 AM 21 3X3   6002836.08721 2107485.6498 37.7669142960875 -122.43345361721 (37.7669142960875, -122.43345361721)
26487 189910 3 97 350 Newhall St 11 1 1 2     14 Width 3ft   6016250.22154 2098227.10108 37.742244189916704 -122.386410241063 (37.7422441899167, -122.386410241063)
35881 225050 3 97 500x 27th St 24 11 1 2     11 Width 4ft   6002949.31338 2100070.05084 37.7465592558077 -122.432532251866 (37.7465592558077, -122.432532251866)
50159 27616 3 97 775 McAllister St 4 1 1 2     24 4x4   6005483.48508 2112000.60744 37.7794611228941 -122.424617889559 (37.7794611228941, -122.424617889559)
51434 16506 3 97 325 Newhall St 8 1 1 2     12 3X3   6016450.0254075 2098336.1941648996 37.742554795386894 -122.385726976255 (37.7425547953869, -122.385726976255)
55275 189902 3 97 350 Newhall St 2 1 1 2     12 Width 3ft   6016433.67399 2098382.99048 37.7426823836985 -122.385786776164 (37.7426823836985, -122.385786776164)
67563 14916 3 97 110X Newhall St 10 1 1 2     3 3X3   6017173.30591 2098243.5594200003 37.7423404352704 -122.38321961360701 (37.7423404352704, -122.383219613607)
67565 14919 3 97 110X Newhall St 13 1 1 2     12 3X3   6017351.5544479005 2098138.8848753003 37.7420628687633 -122.38259599628599 (37.7420628687633, -122.382595996286)
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)
78897 20969 3 97 2002X Sunset Blvd 9 1 1 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
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)
79625 14913 3 97 110X Newhall St 7 1 1 2     12 3x3   6017225.13937 2098220.80076 37.7422808088462 -122.383038803855 (37.7422808088462, -122.383038803855)
79676 4925 3 97 195X Newhall St 14 1 1 2     12 3X3   6017015.097207401 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687)
79948 16484 3 97 220 Newhall St 6 1 1 2     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.38421892893899 (37.7425024549748, -122.384218928939)
81285 16511 3 97 330 Newhall St 2 1 1 2     12 3x3   6016438.273030001 2098384.37308 37.7426864345304 -122.385770970205 (37.7426864345304, -122.385770970205)
82357 2507 3 97 1501 Burke Ave 3 1 1 2     12 3X3   6016682.7889975 2098765.8378067003 37.743747386445996 -122.384952066789 (37.743747386446, -122.384952066789)
82455 14908 3 97 110X Newhall St 2 1 1 2     12 3x3   6017351.5544479005 2098138.8848753003 37.7420628687633 -122.38259599628599 (37.7420628687633, -122.382595996286)
82964 13332 3 97 145 Mansell St 2 1 1 2     6 3X3   6011384.17484 2090567.17856 37.7209410845847 -122.402697063866 (37.7209410845847, -122.402697063866)
83106 16498 3 97 305X Newhall St 9 1 1 2     6 3x3   6016898.459480001 2098256.16023 37.7423598423185 -122.38417083560499 (37.7423598423185, -122.384170835605)
86724 14925 3 97 320X Newhall St 2 1 1 2     12 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
87292 16507 3 97 325 Newhall St 9 1 1 2     12 3x3   6016604.68474 2098314.9336900003 37.7425049753024 -122.385190723599 (37.7425049753024, -122.385190723599)
88469 96756 3 97 1820X Palou Ave 4 1 1 2     3 3x3   6013661.38712 2096183.48051 37.736489188553 -122.395218577377 (37.736489188553, -122.395218577377)
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)
89437 16489 3 97 220 Newhall St 11 1 1 2     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.38421892893899 (37.7425024549748, -122.384218928939)
89537 21785 3 97 2585 Taylor St 1 1 1 2     12 4X4   6008161.90241 2121549.7946200003 37.8058317424248 -122.41602851933997 (37.8058317424248, -122.41602851934)
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)
91297 15123 3 97 300 Mission St 3 1 1 2     14 2X2   6013765.88916 2116013.74101 37.7909445343765 -122.396246681474 (37.7909445343765, -122.396246681474)
91802 14926 3 97 320X Newhall St 3 1 1 2     12 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
92151 2522 3 97 1555 Burke Ave 10 1 1 2     12 3X3   6016344.0270005 2099019.0971083 37.744424041089395 -122.386141087772 (37.7444240410894, -122.386141087772)
92209 14930 3 97 320X Newhall St 7 1 1 2     6 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
92651 6652 3 97 495X Newhall St 8 1 1 2     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472)
93430 14909 3 97 110X Newhall St 3 1 1 2     12 3x3   6017336.92539 2098155.67833 37.7421081720326 -122.382647747732 (37.7421081720326, -122.382647747732)
93500 15124 3 97 300 Mission St 4 1 1 2     14 2X2   6013752.67684 2116000.07901 37.7909062865319 -122.396291437927 (37.7909062865319, -122.396291437927)
94061 94895 3 97 43 Flora St 4 1 1 4 2 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.732132475471104 -122.39381008289601 (37.7321324754711, -122.393810082896)
94554 2524 3 97 1570 BURKE AVE 2 1 1 2   02/12/2016 12:00:00 AM 12 3X3   6016449.0 2099041.0 37.7444899913278 -122.38577963578699 (37.7444899913278, -122.385779635787)
94704 94894 3 97 43 Flora St 3 1 1 4 2 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.732132475471104 -122.39381008289601 (37.7321324754711, -122.393810082896)
96782 16520 3 97 330 Newhall St 11 1 1 2     3 3X3   6016409.970087901 2098376.06541 37.742662057146795 -122.385868255606 (37.7426620571468, -122.385868255606)
97576 21793 3 97 2598 Taylor St 2 1 1 2     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.41507438015499 (37.8060518410095, -122.415074380155)
97633 16512 3 97 330 Newhall St 3 1 1 2     6 3x3   6016415.99739 2098380.53365 37.7426746595649 -122.38584772611999 (37.7426746595649, -122.38584772612)
97917 14920 3 97 110X Newhall St 14 1 1 2     12 3X3   6017135.89317 2098259.62578 37.7423824826909 -122.383350094901 (37.7423824826909, -122.383350094901)
97975 14927 3 97 320X Newhall St 4 1 1 2     6 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
98026 15122 3 97 300 Mission St 2 1 1 2     8 2X2   6013811.40838 2116056.32171 37.791063983762896 -122.396092171091 (37.7910639837629, -122.396092171091)
98540 16491 3 97 305X Newhall St 2 1 1 2     12 3x3   6016683.0708800005 2098298.50072 37.7424641896573 -122.384918540359 (37.7424641896573, -122.384918540359)
99918 2546 3 97 1590X Burke Ave 4 1 1 2     12 3X3   6016148.3291237 2099227.8294693 37.744986343975704 -122.38683233058599 (37.7449863439757, -122.386832330586)
100205 2512 3 97 1501 Burke Ave 8 1 1 2     12 3X3   6016682.7889975 2098765.8378067003 37.743747386445996 -122.384952066789 (37.743747386446, -122.384952066789)
100227 16500 3 97 325 Newhall St 2 1 1 2     12 3X3   6016450.0254075 2098336.1941648996 37.742554795386894 -122.385726976255 (37.7425547953869, -122.385726976255)
102458 22886 3 97 95X Valencia St 2 1 1 2     30 3x3   6006042.93395 2109155.55847 37.771680885423606 -122.422480302267 (37.7716808854236, -122.422480302267)
102486 14932 3 97 320X Newhall St 9 1 1 2     12 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
102582 16504 3 97 325 Newhall St 6 1 1 2     12 3X3   6016450.0254075 2098336.1941648996 37.742554795386894 -122.385726976255 (37.7425547953869, -122.385726976255)
103628 21776 3 97 2500X Taylor St 1 1 1 2     12 3X3   6008409.452819999 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523)
103848 14914 3 97 110X Newhall St 8 1 1 2     12 3x3   6017206.58246 2098230.05631 37.742305197314295 -122.383103612647 (37.7423051973143, -122.383103612647)
104168 94893 3 97 43 Flora St 2 1 1 4 2 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.732132475471104 -122.39381008289601 (37.7321324754711, -122.393810082896)
107427 6650 3 97 495X Newhall St 6 1 1 2     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472)
108484 16515 3 97 330 Newhall St 6 1 1 2     6 3X3   6016409.970087901 2098376.06541 37.742662057146795 -122.385868255606 (37.7426620571468, -122.385868255606)
108888 16502 3 97 325 Newhall St 4 1 1 2     12 3X3   6016450.0254075 2098336.1941648996 37.742554795386894 -122.385726976255 (37.7425547953869, -122.385726976255)
109094 20967 3 97 2002X Sunset Blvd 7 1 1 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
109213 18922 3 97 2620 SACRAMENTO ST 1 1 1 2     12 3x3   6002038.8 2115762.8 37.7895960030005 -122.436803887406 (37.7895960030005, -122.436803887406)
110164 2510 3 97 1501 Burke Ave 6 1 1 2     12 3X3   6016682.7889975 2098765.8378067003 37.743747386445996 -122.384952066789 (37.743747386446, -122.384952066789)
110305 6648 3 97 495X Newhall St 4 1 1 2     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472)
110644 16505 3 97 325 Newhall St 7 1 1 2     12 3X3   6016450.0254075 2098336.1941648996 37.742554795386894 -122.385726976255 (37.7425547953869, -122.385726976255)
110804 21781 3 97 2550X Taylor St 1 1 1 2   08/12/2011 12:00:00 AM 3 4x4   6008458.5658599995 2121488.77145 37.805680863133205 -122.41499754514 (37.8056808631332, -122.41499754514)
111285 2541 3 97 1575 Burke Ave 9 1 1 2     12 3X3   6016218.6051359 2099112.8628025004 37.7446745598911 -122.38658131155898 (37.7446745598911, -122.386581311559)
111965 16519 3 97 330 Newhall St 10 1 1 2     3 3X3   6016409.970087901 2098376.06541 37.742662057146795 -122.385868255606 (37.7426620571468, -122.385868255606)
112145 6850 3 97 595X Newhall St 7 1 1 2   01/22/1998 12:00:00 AM 12 3x3   6015895.1615953 2097662.6258274 37.740674595672296 -122.387598567026 (37.7406745956723, -122.387598567026)
112168 21794 3 97 2598 Taylor St 3 1 1 2     21 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.41507438015499 (37.8060518410095, -122.415074380155)
112741 16513 3 97 330 Newhall St 4 1 1 2     12 3x3   6016404.80629 2098376.61978 37.742663293572505 -122.38588614932699 (37.7426632935725, -122.385886149327)
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)
114992 116858 3 97 180 NOE ST 1 1 1 2     14 3x3   6002788.0 2107242.0 37.7662425648461 -122.43360252819201 (37.7662425648461, -122.433602528192)
116558 21795 3 97 2598 Taylor St 4 1 1 2     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.41507438015499 (37.8060518410095, -122.415074380155)
116667 14918 3 97 110X Newhall St 12 1 1 2     12 3X3   6017351.5544479005 2098138.8848753003 37.7420628687633 -122.38259599628599 (37.7420628687633, -122.382595996286)
116782 4389 3 97 56 Chilton Ave 2 1 1 2   06/09/2008 12:00:00 AM 30 3x3   6001657.8215553 2095631.9001159 37.7342998083721 -122.436680450501 (37.7342998083721, -122.436680450501)
117916 4913 3 97 195X Newhall St 2 1 1 2     6 3X3   6017015.097207401 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687)
118155 14929 3 97 320X Newhall St 6 1 1 2     6 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
118268 14924 3 97 320X Newhall St 1 1 1 2     12 3X3   6016461.7664057 2098387.7906820998 37.7426971185746 -122.38568997425199 (37.7426971185746, -122.385689974252)
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)
119228 94892 3 97 43 Flora St 1 1 1 4 2 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.732132475471104 -122.39381008289601 (37.7321324754711, -122.393810082896)
119784 16497 3 97 305X Newhall St 8 1 1 2     6 3x3   6016834.58957 2098268.17724 37.7423893070591 -122.384392517318 (37.7423893070591, -122.384392517318)
120157 17414 3 97 1820X Palou Ave 3 1 1 2     12 3x3   6013664.43707 2096187.44321 37.7365002389252 -122.39520830982599 (37.7365002389252, -122.395208309826)
120176 6646 3 97 495X Newhall St 2 1 1 2   04/01/1990 12:00:00 AM 18 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472)
122367 4918 3 97 195X Newhall St 7 1 1 2     12 3X3   6017015.097207401 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687)
122698 16510 3 97 330 Newhall St 1 1 1 2     12 3x3   6016409.970087901 2098376.06541 37.742662057146795 -122.385868255606 (37.7426620571468, -122.385868255606)
123471 6651 3 97 495X Newhall St 7 1 1 2     18 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472)
124291 4926 3 97 195X Newhall St 15 1 1 2     12 3X3   6017015.097207401 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687)
124746 14912 3 97 110X Newhall St 6 1 1 2     12 3x3   6017247.980359999 2098210.14599 37.742252815079496 -122.38295908456999 (37.7422528150795, -122.38295908457)
Powered by Datasette · Query took 21.491ms · Data source: data.sfgov.org