sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10 122670 1 8 301x Hickory St 3 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
76 241180 1 31 300 Duboce Ave 3 7 1 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004770.13014 2108408.30025 37.7695572102182 -122.426829784767 (37.7695572102182, -122.426829784767)
122 183689 1 45 1341 42nd Ave 3 1 1 1     6 Width 0ft   5983043.6112 2105976.497 37.761627789464704 -122.501799836383 (37.7616277894647, -122.501799836383)
132 116641 1 44 270 Brannan St 3 5 1 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
159 97322 1 48 1055 Taraval St 3 1 1 1   03/28/2017 12:42:00 PM 3 3x3   5989910.3078 2099001.0945 37.7428761380219 -122.477541124233 (37.7428761380219, -122.477541124233)
193 6069 1 2 1930 Eddy St 3 1 1 1   05/26/2015 12:00:00 AM 3 3X3   6001175.3543 2112495.6639 37.7805761758993 -122.439557004629 (37.7805761758993, -122.439557004629)
194 138802 1 46 2375 PINE ST 3 1 1 1     12 Width 0ft   6002539.8455 2115065.9469 37.787711085766894 -122.435020465254 (37.7877110857669, -122.435020465254)
200 134567 1 15 99 Grove St 3 1 1 5   07/06/2011 12:00:00 AM 4 Width 4ft   6007561.6986 2111595.58464 37.778466176805296 -122.417399738421 (37.7784661768053, -122.417399738421)
322 7968 1 26 1901 Franklin St 3 1 1 1   10/03/2007 12:00:00 AM 3 3X3   6005627.24821 2116610.0246200003 37.7921255585096 -122.42444850412 (37.7921255585096, -122.42444850412)
554 31894 1 96 333 12th St 3 1 1 1 1 06/26/1995 12:00:00 AM 6   Permit Number 35323 6008421.36423 2108725.6861900003 37.7706344442547 -122.41422271959999 (37.7706344442547, -122.4142227196)
577 15499 1 26 2704 Mission St 3 1 1 1     12 3X3   6006991.0 2102555.0 37.7536107294676 -122.41873270043001 (37.7536107294676, -122.41873270043)
578 239543 1 52 91 Bennington St 3 1 1 1   04/12/2017 12:00:00 AM 3 2.5x4 Permit Number 779298 6007186.362369999 2097372.9446900003 37.7393929694044 -122.41768982014798 (37.7393929694044, -122.417689820148)
591 139532 1 89 2103 O'Farrell St 3 1 1 1   04/12/2017 12:00:00 AM 3 Width 0ft Permit Number 779818 6001200.3588 2113145.5057 37.7823618989571 -122.439517100245 (37.7823618989571, -122.439517100245)
597 251329 1 17 95x Tompkins Ave 3 1 1 1   02/10/2017 12:00:00 AM   3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
621 251339 1 51 2230 Ocean Ave 3 1 1 1 4 05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
687 13252 1 79 2395 Lombard St 3 1 1 1     14 3X3   6001005.1632 2119265.163 37.7991537757264 -122.440631471061 (37.7991537757264, -122.440631471061)
739 13244 1 79 2353 Lombard St 3 1 1 1   02/18/2012 12:00:00 AM 3 3x3   6001169.3018 2119289.54 37.7992300540772 -122.44006524578501 (37.7992300540772, -122.440065245785)
741 9506 1 22 935 Golden Gate Ave 3 1 1 1   01/10/2002 12:00:00 AM 3 3X3   6005056.2117 2112292.3227 37.7802379614696 -122.426116783326 (37.7802379614696, -122.426116783326)
743 224663 1 17 614 Alabama St 3 1 1 1   04/18/2017 12:00:00 AM 3 5x5 Permit Number 779497 6008964.71968 2105285.1997599998 37.761218168313704 -122.412100053373 (37.7612181683137, -122.412100053373)
775 231005 1 22 660 Alabama St 3 1 1 1   01/14/2003 12:00:00 AM 8 Width 3ft Permit Number 46247 6008971.29667 2105087.04019 37.7606744364044 -122.41206330170401 (37.7606744364044, -122.412063301704)
809 46145 1 17   3 1 1 1   12/27/2001 12:00:00 AM     Permit Number 44490          
862 141567 1 17 501X Baker St 3 1 1 1   04/20/2017 12:00:00 AM 3 Width 0ft Permit Number 779825 6000588.8239 2110706.7362 37.7756308363396 -122.44145768074499 (37.7756308363396, -122.441457680745)
1017 6253 1 79 1315 Ellis St 3 1 1 1   10/05/2004 12:00:00 AM 9 3X3   6004522.7205 2113262.2432 37.782870955582794 -122.428031512738 (37.7828709555828, -122.428031512738)
1054 125462 1 70 125 Mason St 3 1 1 1   04/28/2017 12:00:00 AM 3 Width 4ft Permit Number 52121 6009895.29665 2113891.24599 37.7849005400769 -122.40948896803499 (37.7849005400769, -122.409488968035)
1125 38267 1 87 1300 22nd St 3 1 1 1   05/03/2017 12:00:00 AM 3   Permit Number 40367 6014066.98761 2103880.20359 37.757645313792295 -122.39435496983299 (37.7576453137923, -122.394354969833)
1128 38275 1 87 651 Texas St 3 1 1 1   05/03/2017 12:00:00 AM 3   Permit Number 40367 6013943.54254 2103938.72902 37.7577991491248 -122.394785995079 (37.7577991491248, -122.394785995079)
1176 246082 1 59 1390 Waller St 3 1 1 1     11 Width 0ft   5999092.1637 2108384.801 37.7691700156221 -122.44646789257601 (37.7691700156221, -122.446467892576)
1216 244031 1 16 501X Shrader St 3 1 1 1   11/18/1999 12:00:00 AM 6 Width 0ft Permit Number 41876 5997510.0 2108663.0 37.7698433835647 -122.45196055507601 (37.7698433835647, -122.451960555076)
1229 235065 1 26 2400 Diamond St 3 1 1 1   07/29/1997 12:00:00 AM 6 Width 2ft Permit Number 38465 6001951.69941 2097144.86437 37.7384707551305 -122.43577263420299 (37.7384707551305, -122.435772634203)
1237 103805 1 18 98X Hemlock St 3 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006953.73656 2114843.50125 37.7873499398897 -122.41973342786999 (37.7873499398897, -122.41973342787)
1269 251332 1 138 920X Shotwell St 3 1 1 1   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007731.0 2102403.0 37.753235008598104 -122.416162845847 (37.7532350085981, -122.416162845847)
1275 4132 1 8 3550 Cesar Chavez St 3 1 1 2   05/09/2017 12:00:00 AM 3 3x3   6006390.9849 2100603.33536 37.7482181038931 -122.420669151754 (37.7482181038931, -122.420669151754)
1374 97285 1 41 2321 Webster St 3 1 1 1   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773461 6003155.0 2116788.0 37.7924743139296 -122.433015230869 (37.7924743139296, -122.433015230869)
1446 139885 1 26 1575 TURK ST 3 1 1 1   04/23/1990 12:00:00 AM 6 Width 0ft   6002581.4123 2112293.0339 37.7800997287845 -122.434678293337 (37.7800997287845, -122.434678293337)
1476 139882 1 26 1585 TURK ST 3 1 1 1   04/23/1990 12:00:00 AM 14 Width 0ft   6002483.27 2112280.1738 37.780058846079605 -122.435016891621 (37.7800588460796, -122.435016891621)
1483 251556 1 17 299 Clinton Park 3 1 1 1       3x3   6004847.0 2108161.0 37.7688825293039 -122.42654628279399 (37.7688825293039, -122.426546282794)
1485 115988 1 30 499 Jackson St 3 1 1 1   06/09/2016 12:00:00 AM 3 3x3 Permit Number 777967 6011781.45666 2118040.71778 37.7963995082912 -122.40325542520901 (37.7963995082912, -122.403255425209)
1515 243950 1 75 10 South Van Ness Ave 3 1 1 1   07/14/2004 12:00:00 AM 13 Width 5ft Permit Number 47529 6007004.81099 2110130.42285 37.774411845966895 -122.419222267617 (37.7744118459669, -122.419222267617)
1617 88497 1 12 1701 Lane St 3 1 1 1   07/18/2008 12:00:00 AM 4 3x3 Permit Number 51438 6015090.0 2094306.0 37.7314133544089 -122.390148092066 (37.7314133544089, -122.390148092066)
1622 15770 1 94 4770 Mission St 3 1 1 1   06/29/2007 12:00:00 AM 3 3X3   6001421.7162 2091049.3752 37.721703820816394 -122.43716874658399 (37.7217038208164, -122.437168746584)
1721 23308 1 15 1000 Van Ness Ave 3 1 1 1   06/30/1998 12:00:00 AM 5 3X3   6006538.20918 2114040.94612 37.785122904641796 -122.42111406077 (37.7851229046418, -122.42111406077)
1864 44087 1 17 500 Bryant St 3 1 1 1   06/08/2017 12:00:00 AM 3 3x3 Permit Number 780030 6013716.56338 2112456.73733 37.7811750796017 -122.396167952707 (37.7811750796017, -122.396167952707)
1989 133618 1 15 150 Richardson Ave 3 1 1 1     18 Width 4ft   5999272.2292 2119684.41545 37.8002060956892 -122.446658172159 (37.8002060956892, -122.446658172159)
2010 142062 1 55 1100 Golden Gate Ave 3 1 1 3   01/02/2014 12:00:00 AM 10 Width 0ft Permit Number 771276 6004214.4178 2112228.4 37.780014831771 -122.429024376887 (37.780014831771, -122.429024376887)
2018 238617 1 15 4302 24th St 3 1 1 1   12/27/2012 12:00:00 AM 5 Width 4ft Permit Number 769743 6001157.09349 2101748.35409 37.751065679453504 -122.438849790481 (37.7510656794535, -122.438849790481)
2020 40822 1 16 695 05th St 3 1 1 1   08/26/1999 12:00:00 AM 3 3x3 Permit Number 41762 6013323.14167 2110435.9074 37.775604443222704 -122.39738724541901 (37.7756044432227, -122.397387245419)
2062 8436 1 168 1730 Geary Blvd 3 1 1 1   05/28/1997 12:00:00 AM 11 3X3   6003412.8094 2113950.8814 37.784698926436796 -122.431920527552 (37.7846989264368, -122.431920527552)
2065 141406 1 104 500 IVY ST 3 1 1 1   04/12/1995 12:00:00 AM 6 Width 0ft Permit Number 34950 6004860.5862 2111087.89 37.77691982656621 -122.42670774733699 (37.7769198265662, -122.426707747337)
2078 12419 1 16 1691 Laguna St 3 1 1 1   06/11/1997 12:00:00 AM 3 4X4   6004453.7544 2114557.5752 37.786423711867705 -122.42836245915599 (37.7864237118677, -122.428362459156)
2080 34119 1 12   3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37980          
2098 97613 1 101 353 10th St 3 1 1 1   06/21/2017 12:00:00 AM 3 3x3 Permit Number 780019 6009097.30811 2109294.5871599996 37.7722344586718 -122.411924820485 (37.7722344586718, -122.411924820485)
2172 43089 1 171 240 Jones St 3 1 1 1 1 07/07/2000 12:00:00 AM 15   Permit Number 42924 6009028.16004 2113458.59755 37.783663965959995 -122.41245839903999 (37.78366396596, -122.41245839904)
2221 143495 1 44 800 KEARNY ST 3 1 1 1   04/10/2009 12:00:00 AM 1 Width 0ft Permit Number 52103 6011293.9321 2117775.1194 37.795642999547894 -122.40492366345501 (37.7956429995479, -122.404923663455)
2227 129057 1 44 662 Washington St 3 1 1 1   04/10/2009 12:00:00 AM 2 Width 3ft Permit Number 52103 6011354.55314 2117688.13829 37.7954075587569 -122.404707776336 (37.7954075587569, -122.404707776336)
2244 34670 1 37 2001X Filbert St 3 1 1 1   05/22/2015 12:00:00 AM 3 3x3 Permit Number 38339 6003296.78192 2118922.23396 37.798342411735604 -122.432677184799 (37.7983424117356, -122.432677184799)
2276 252994 1 73 1201 Tennessee St 3 1 1 1   07/10/2017 12:00:00 AM 3     6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
2310 102805 1 88 600 Kansas St 3 1 1 1   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011492.26434 2105507.65774 37.7619704808857 -122.403373953167 (37.7619704808857, -122.403373953167)
2380 253068 1 44 420 Innes Ave 3 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770367 6021281.0075199995 2092952.36789 37.7280379741387 -122.368650880757 (37.7280379741387, -122.368650880757)
2389 201587 1 11 451 Donahue St 3 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6021008.9496 2093419.1731599998 37.729304811746104 -122.36962364951799 (37.7293048117461, -122.369623649518)
2421 253064 1 174 451 Hudson Ave 3 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770412 6021215.947000001 2093217.369 37.728762049698204 -122.36889409743 (37.7287620496982, -122.36889409743)
2430 201600 1 15 98 Kirkwood Ave 3 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020594.26008 2092766.53995 37.7274900446232 -122.371012172182 (37.7274900446232, -122.371012172182)
2437 201591 1 11 501 Donahue St 3 1 1 1   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020744.06411 2093067.1780599998 37.7283237638216 -122.37051506831001 (37.7283237638216, -122.37051506831)
2448 253050 1 11 101 Donahue St 3 1 1 1   07/12/2017 12:00:00 AM 3 3x3   6020868.84401 2093226.3884400001 37.728767773737104 -122.3700946933 (37.7287677737371, -122.3700946933)
2454 201833 1 48 350 Friedell St 3 1 1 1   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020733.63229 2092847.8779900002 37.727721034575296 -122.370535976659 (37.7277210345753, -122.370535976659)
2462 253060 1 174 421 Hudson Ave 3 1 1 1   07/12/2017 12:00:00 AM 3   Permit Number 770411 6021349.4 2093117.8080000002 37.728495991679296 -122.368425863032 (37.7284959916793, -122.368425863032)
2473 253095 1 21 1201 29th Ave 3 1 1 1   07/13/2017 12:00:00 AM 3 3x3 Permit Number 779996 5987047.82966 2107087.0186099997 37.7649113707945 -122.488032657316 (37.7649113707945, -122.488032657316)
2507 137731 1 17 610 Lyon St 3 1 1 1   07/17/2017 12:00:00 AM 3 3x3 Permit Number 780365 6000144.0 2111022.0 37.7764711190239 -122.44301907684799 (37.7764711190239, -122.443019076848)
2615 253153 1 11 2030 03rd St 3 1 1 1   02/02/2017 12:00:00 AM     Permit Number 779475 6015677.29531 2106131.10604 37.763915191309295 -122.38894296750799 (37.7639151913093, -122.388942967508)
2633 108358 1 52 250X Pixley St 3 1 1 11   12/17/2014 12:00:00 AM 3 2x4 Permit Number 773698 6002123.0245900005 2118966.98612 37.798398653541796 -122.43674193970399 (37.7983986535418, -122.436741939704)
2644 124734 1 17 999 Brannan St 3 1 1 1           6010535.71931722 2108464.76902983 37.7700365636667 -122.406890710328 (37.7700365636667, -122.406890710328)
2674 223658 1 49 336 Bosworth St 3 1 1 1     5 Width 3ft Permit Number 18811 6003665.26948 2095270.38526 37.7334210492488 -122.429714281988 (37.7334210492488, -122.429714281988)
2719 141993 1 6 818 Webster St 3 1 1 1   04/21/2008 12:00:00 AM 2 Width 0ft   6003993.152000001 2111582.4748 37.778228754000004 -122.429743751351 (37.778228754, -122.429743751351)
2797 142505 1 59 620 Vallejo St 3 1 1 1   12/17/2014 12:00:00 AM 22 Width 0ft Permit Number 774306 6010566.6807 2118940.2612 37.7988015168915 -122.407522281284 (37.7988015168915, -122.407522281284)
2826 28035 1 15 1500 The Embarcadero 3 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011869.41049 2121075.03017 37.804735906188796 -122.403164632367 (37.8047359061888, -122.403164632367)
2842 36843 1 155   3 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
2898 114413 1 60 1345 Taylor St 3 1 1 1     22     6008903.22514 2117506.21986 37.7947707425189 -122.413176939363 (37.7947707425189, -122.413176939363)
2908 140145 1 59 2077 HAYES ST 3 1 1 1     10 Width 0ft   5997912.6072 2109907.6306 37.7732838718856 -122.45065770078699 (37.7732838718856, -122.450657700787)
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)
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)
2981 245990 1 79 1250 Waller St 3 1 1 1   01/07/2010 12:00:00 AM 11 Width 0ft Permit Number 53135 5999824.4044 2108487.46 37.76949368743671 -122.44394249781901 (37.7694936874367, -122.443942497819)
3011 142167 1 60 1477 GROVE ST 3 1 1 1     14 Width 0ft   6000740.7568 2110654.3455 37.775495639126795 -122.440928349683 (37.7754956391268, -122.440928349683)
3012 222459 1 28 103 Germania St 3 1 1 1   12/04/1996 12:00:00 AM 12 Width 3ft Permit Number 37768 6003745.35961 2108826.05534 37.7706462694291 -122.430404237367 (37.7706462694291, -122.430404237367)
3013 39333 1 35 0 21st St 3 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
3060 203634 1 42 432 Flood Ave 3 1 1 1   06/23/2000 12:00:00 AM 11 Width 2ft Permit Number 42544 5997859.0322900005 2094116.10367 37.7299211747225 -122.449704832412 (37.7299211747225, -122.449704832412)
3062 34116 1 12   3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37979          
3098 227979 1 62 200 29th St 3 1 1 1   11/02/2006 12:00:00 AM 6 Width 3ft Permit Number 49086 6005126.89466 2099045.69197 37.7438698467248 -122.424929536192 (37.7438698467248, -122.424929536192)
3101 102774 1 37 1472 Filbert St 3 1 1 1     8 3x3 Permit Number 31200 6005947.91695 2119337.23456 37.7996318920616 -122.42353296190201 (37.7996318920616, -122.423532961902)
3105 199929 1 79 1801 Ingalls St 3 1 1 11   02/28/2006 12:00:00 AM 6 Width 0ft   6016487.4596 2092903.0942 37.727638663365 -122.385219049049 (37.727638663365, -122.385219049049)
3160 109437 1 15 940 Grove St 3 1 1 1     16 4x6   6003136.3777 2111029.1486 37.7766609049 -122.432668109569 (37.7766609049, -122.432668109569)
3201 150469 1 150 100 Southern Heights Ave 3 1 1 1   08/24/2017 12:00:00 AM 3 Width 2ft Permit Number 776550 6012042.59416 2104165.28662 37.758315349182794 -122.40137622523899 (37.7583153491828, -122.401376225239)
3207 253355 1 35 1705 Buchanan St 3 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3212 34102 1 12   3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37975          
3225 253351 1 35 1756 Buchanan St 3 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3233 253345 1 35 1700 Buchanan St 3 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3281 245417 1 202 2761 24th St 3 1 1 1   08/29/2017 12:00:00 AM 3 4x4 Permit Number 780031 6010192.4103 2102204.1541 37.7528271142349 -122.407636730621 (37.7528271142349, -122.407636730621)
3287 253411 1 11 1321 Mission St 3 1 2 1   08/30/2017 12:00:00 AM 3 4x12 Permit Number 775218 6008256.52806819 2110680.03106396 37.775991353803896 -122.414931236288 (37.7759913538039, -122.414931236288)
3334 140424 1 59 1499 TURK ST 3 1 1 18     13 Width 0ft   6002981.8736 2112352.3525 37.7802853291655 -122.43329715719 (37.7802853291655, -122.43329715719)
3340 140461 1 26 1410 TURK ST 3 1 1 1   08/01/1991 12:00:00 AM 7 Width 0ft   6003069.601 2112407.5024 37.780441733392 -122.432997609121 (37.780441733392, -122.432997609121)
3352 140464 1 37 1440 TURK ST 3 1 1 1   01/19/2001 12:00:00 AM 4 Width 0ft   6002964.8193 2112393.1435 37.780396363522 -122.433359071525 (37.780396363522, -122.433359071525)
3364 188226 1 61 1350 19th St 3 4 1 1   11/01/1996 12:00:00 AM 6 Width 3ft Permit Number 37286 6013575.41694 2105253.06849 37.7613875637091 -122.396151246903 (37.7613875637091, -122.396151246903)
3389 243477 1 88 109 Jarboe Ave 3 1 1 1   09/05/2017 12:00:00 AM 3 3x3 Permit Number 779653 6007827.749919999 2097028.5645299999 37.7384834490575 -122.415447803985 (37.7384834490575, -122.415447803985)
Powered by Datasette · Query took 2.872ms · Data source: data.sfgov.org