sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
20 251179 4 13 1043 Minna St 2 5 1 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
21 251178 4 13 1043 Minna St 1 5 1 1       3x3   6007668.0 2109797.0 37.7735336727503 -122.41690453761002 (37.7735336727503, -122.41690453761)
54 121137 4 26 1388x Minna St 1 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
60 121139 4 26 1388x Minna St 3 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
70 121138 4 26 1388x Minna St 2 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
224 117019 4 2 168 Hyde St 3 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.41556230388201 (37.782365960952, -122.415562303882)
361 85803 4 69 923 Folsom St 1 1 1 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011427.0378 2111936.1074 37.779617893816 -122.40405196806002 (37.779617893816, -122.40405196806)
394 85804 4 69 923 Folsom St 2 1 1 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011441.4589 2111949.4191 37.7796552503769 -122.404003016031 (37.7796552503769, -122.404003016031)
518 251314 4 54 1108 Diamond St 1 1 1 1       3x3   6001901.0 2100825.0 37.7485726639367 -122.43621121860001 (37.7485726639367, -122.4362112186)
533 251313 4 54 390 28th St 1 1 1 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
948 251406 4 12 445 Amazon Ave 1 1 1 1   04/25/2017 12:00:00 AM 3 3x3   6001636.0 2088904.0 37.7158252789105 -122.43627456666799 (37.7158252789105, -122.436274566668)
976 160371 4 12 868 Edinburgh St 3 1 1 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001686.38396 2088939.3945099998 37.7159253269669 -122.43610294800199 (37.7159253269669, -122.436102948002)
977 242613 4 46 48 Winfield St 1 1 1 1     11 3x3 Permit Number 777782 6007306.44134 2099195.30791 37.744403529591395 -122.417403753004 (37.7444035295914, -122.417403753004)
991 160369 4 12 868 Edinburgh St 1 1 1 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001700.06015 2088961.7176 37.715987398188894 -122.436057273237 (37.7159873981889, -122.436057273237)
994 160370 4 12 868 Edinburgh St 2 1 1 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001693.73373 2088950.71414 37.715956825716 -122.436078353349 (37.715956825716, -122.436078353349)
1180 251470 4 37 194 Sweeny St 1 1 1 1   05/04/2017 12:00:00 AM 3 3x3 Permit Number 777454 6009558.57553 2094850.0846799999 37.7325989441491 -122.409309728531 (37.7325989441491, -122.409309728531)
1436 251534 4 37 1818 42nd Ave 1 1 1 1   05/16/2017 12:00:00 AM 3 3x3   5983226.0 2102732.0 37.7527300247516 -122.500929082058 (37.7527300247516, -122.500929082058)
1451 251539 4 115 1746 Great Hwy 2 1 1 1       3x3   5981086.0 2103156.0 37.753768326371 -122.50836092480499 (37.753768326371, -122.508360924805)
1459 251538 4 115 1746 Great Hwy 1 1 1 1   10/27/2001 12:00:00 AM   3x3   5981086.0 2103156.0 37.753768326371 -122.50836092480499 (37.753768326371, -122.508360924805)
1934 252840 4 17 80 Blake St 1 1 1 1       3x3   5997842.0 2113206.0 37.782336294689 -122.45113984781099 (37.782336294689, -122.451139847811)
2025 243143 4 12 98x Eugenia Ave 1 1 1 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
2032 243144 4 12 98x Eugenia Ave 2 1 1 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
2142 252906 4 26 600 South Van Ness Ave 2 1 1 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2143 252905 4 26 600 South Van Ness Ave 1 1 1 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2147 252908 4 26 600 South Van Ness Ave 3 1 1 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2571 253124 4 17 399x Lexington St 1 1 1 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780530          
2575 253126 4 26 182 London St   1 1 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 779117 6002742.73008 2092646.2038099999 37.726163358663705 -122.432716365158 (37.7261633586637, -122.432716365158)
2639 253101 4 12 3000x Irving St 1 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2642 253105 4 12 1295 31st Ave 1 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2663 253102 4 12 3000x Irving St 2 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2666 253103 4 12 3000x Irving St 3 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2669 253104 4 12 3000x Irving St 4 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2715 253166 4 82 2405 32nd Ave 1 1 1 1   07/31/2017 12:00:00 AM 3 3x3 Permit Number 778209 5986396.6612 2098868.17463 37.742306656921 -122.48968039586501 (37.742306656921, -122.489680395865)
2759 253203 4 120 349 Mangels Ave 1 5 1 1       3x3   5999103.0 2095207.0 37.732987611392005 -122.44548271607799 (37.732987611392, -122.445482716078)
2853 253248 4 75 570 Jessie St 2 1 1 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
2868 253247 4 75 570 Jessie St 1 1 1 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
2897 253249 4 75 570 Jessie St 3 1 1 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
3030 224462 4 30 2810 26th St 2 1 1 1   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010311.37562 2101086.64633 37.7497653433983 -122.40714655877301 (37.7497653433983, -122.407146558773)
3035 240686 4 30 2810 26th St 1 1 1 1   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010325.27315 2101087.17666 37.749767577309605 -122.40709853768499 (37.7497675773096, -122.407098537685)
3048 253287 4 17 1237 Shafter Ave 1 1 1 1   08/16/2017 12:00:00 AM 3 3x3 Permit Number 780510 6016839.12241 2092718.7941400001 37.727152059320204 -122.383990506478 (37.7271520593202, -122.383990506478)
3083 252820 4 49 2339 41st Ave 1 1 1 1   08/21/2017 12:00:00 AM 3 3x3   5983590.30233 2099230.6863599997 37.743137766616 -122.49941055724301 (37.743137766616, -122.499410557243)
3172 253340 4 52 1045 Church St 1 1 1 1   08/23/2017 12:00:00 AM 3 3x3 Permit Number 780536 6004432.85841 2102813.20591 37.754175338839204 -122.427597715268 (37.7541753388392, -122.427597715268)
3255 253377 4 54 2 Alpine Ter 1 1 1 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)
3275 253378 4 54 2 Alpine Ter 2 1 1 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)
3289 253392 4 46 115 Steuart St 1 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3293 253393 4 46 115 Steuart St 2 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3316 253394 4 46 115 Steuart St 3 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3345 253419 4 54 3499 Jackson St 1 1 1 1       3x3   5997570.0 2115996.0 37.78998131889129 -122.452282225129 (37.7899813188913, -122.452282225129)
3525 253489 4 31 1x Gordon St 7 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3532 253483 4 31 1x Gordon St 1 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3533 253491 4 31 1x Gordon St 9 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3538 253485 4 31 1x Gordon St 3 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3546 253495 4 31 1x Gordon St 13 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3553 253492 4 31 1x Gordon St 10 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3554 253490 4 31 1x Gordon St 8 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3555 253487 4 31 1x Gordon St 5 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3562 253488 4 31 1x Gordon St 6 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3563 253493 4 31 1x Gordon St 11 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3573 253496 4 31 1x Gordon St 14 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3581 253486 4 31 1x Gordon St 4 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3582 253484 4 31 1x Gordon St 2 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3587 253494 4 31 1x Gordon St 12 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3753 253554 4 21 1855 30th Ave 1 1 1 1   09/22/2017 12:00:00 AM 3 3x3 Permit Number 778968 5986885.63083 2102641.2721 37.7526951056681 -122.48826692291901 (37.7526951056681, -122.488266922919)
3809 95203 4 51 314 Walnut St 1 1 1 1     0 3x3 Permit Number 769992 5998598.6333800005 2115400.1597599997 37.7884041728517 -122.44868032474 (37.7884041728517, -122.44868032474)
3823 102525 4 37 310 Walnut St 1 1 1 1   01/30/2013 12:00:00 AM 0 3x3 Permit Number 769739 5998596.991169999 2115413.44206 37.7884405486385 -122.448686963531 (37.7884405486385, -122.448686963531)
3868 253576 4 37 2622 Judah St 1 1 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 774112 5986417.0 2105735.0 37.7611622818619 -122.49011505097 (37.7611622818619, -122.49011505097)
4401 239088 4 9 3855 26th St 1 1 1 2     13 3x3 Permit Number 780732 6004794.15723 2100737.4007099997 37.748496089721996 -122.426200479689 (37.748496089722, -122.426200479689)
4434 253623 4 51 1331 39th Ave 1 1 1 1   10/11/2017 12:00:00 AM 3 3x3 Permit Number 778744 5983976.422619999 2106100.27997 37.7620224120695 -122.498582815109 (37.7620224120695, -122.498582815109)
5050 253762 4 54 520 08th Ave 1 1 1 1       3x3   5993490.0 2111935.0 37.778596343165496 -122.46610332918101 (37.7785963431655, -122.466103329181)
5087 150676 4 26 548 Rhode Island St 1 8 1 1   11/07/2017 12:00:00 AM 3 3x3 Permit Number 780811 6011754.983990001 2105812.52377 37.762822244976505 -122.402486741392 (37.7628222449765, -122.402486741392)
5192 243370 4 11 1 Hill St 2 1 1 1   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006249.2279900005 2103449.78821 37.756025819148796 -122.421361454386 (37.7560258191488, -122.421361454386)
5194 243372 4 11 1050 Valencia St 1 1 1 1   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006308.99467 2103436.4955 37.755992689926295 -122.42115381712 (37.7559926899263, -122.42115381712)
5195 253341 4 88 1935 46th Ave 1 5 1 1   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.6810099995 2101921.14451 37.750428327874204 -122.505299944249 (37.7504283278742, -122.505299944249)
5205 243371 4 11 1 Hill St 3 1 1 1   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006273.4727300005 2103450.37091 37.7560287860041 -122.42127764924 (37.7560287860041, -122.42127764924)
5242 243740 4 13 550 Laidley St 1 1 1 1   11/15/2017 12:00:00 AM 3 3x3 Permit Number 776473 6003047.0557699995 2096015.8076799999 37.7354327831918 -122.431904827248 (37.7354327831918, -122.431904827248)
5296 117021 4 2 168 Hyde St 5 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008114.19003 2113031.70239 37.7824404814865 -122.415590162171 (37.7824404814865, -122.415590162171)
5549 117113 4 37 1650 Broadway 2 1 1 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005663.57094 2117913.49378 37.7957066076266 -122.424415580821 (37.7957066076266, -122.424415580821)
5738 117115 4 37 1650 Broadway 4 1 1 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005638.31982 2117909.64088 37.7956946025865 -122.42450268015 (37.7956946025865, -122.42450268015)
5744 117020 4 2 168 Hyde St 4 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008118.25915 2113018.6658799998 37.7824049150971 -122.41557516146601 (37.7824049150971, -122.415575161466)
5891 117112 4 37 1650 Broadway 1 1 1 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005683.22125 2117915.42136 37.7957130098979 -122.424347724294 (37.7957130098979, -122.424347724294)
5966 117017 4 2 168 Hyde St 1 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008130.7573 2112963.51283 37.7822541806174 -122.415528017206 (37.7822541806174, -122.415528017206)
6755 117018 4 2 168 Hyde St 2 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008125.664580001 2112987.05621 37.78231853881321 -122.415547303188 (37.7823185388132, -122.415547303188)
7045 117250 4 16 2474 Broadway 1 1 1 1   09/13/2016 12:00:00 AM 3 3x3 Permit Number 773044 6001780.62325 2117368.05955 37.7939889537763 -122.437812170719 (37.7939889537763, -122.437812170719)
7118 120115 4 8 2225 Bay St 1 1 1 1     2 3x3   6000127.238390001 2120216.52423 37.801715927006796 -122.443737765003 (37.8017159270068, -122.443737765003)
7243 116776 4 37 1106 Pacific Ave 3 1 1 1   04/28/2016 12:00:00 AM 3 3x3   6008776.88904 2117992.21481 37.7960980717264 -122.41364847189399 (37.7960980717264, -122.413648471894)
7304 117114 4 37 1650 Broadway 3 1 1 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005648.88243 2117910.88116 37.7956986045686 -122.42446621984399 (37.7956986045686, -122.424466219844)
7735 116777 4 37 1106 Pacific Ave 4 1 1 1   04/28/2016 12:00:00 AM 3 3x3   6008763.52683 2117990.43413 37.796092432072705 -122.41369458194099 (37.7960924320727, -122.413694581941)
8122 65944 4 44 1051 Post St 1 1 1 1   05/12/2016 12:00:00 AM 3 3x3 Permit Number 774496 6007126.88528 2114657.80083 37.7868498044193 -122.419121190999 (37.7868498044193, -122.419121190999)
8186 35487 4 69 2655 Bush St 2 1 1 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000866.3431 2114483.9624 37.7860179417845 -122.440768684557 (37.7860179417845, -122.440768684557)
8765 116774 4 37 1106 Pacific Ave 1 1 1 1   04/28/2016 12:00:00 AM 3 3x3   6008811.215480001 2117995.14613 37.7961080479024 -122.413529902601 (37.7961080479024, -122.413529902601)
8943 116775 4 37 1106 Pacific Ave 2 1 1 1   04/28/2016 12:00:00 AM 3 3x3   6008794.04431 2117993.28546 37.79610197478279 -122.413589186808 (37.7961019747828, -122.413589186808)
9622 122597 4 9 42X Colin P Kelly Jr St 5 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9623 75842 4 9 42X Colin P Kelly Jr St 2 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9625 122599 4 9 42X Colin P Kelly Jr St 7 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9627 122596 4 9 42X Colin P Kelly Jr St 4 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9628 122598 4 9 42X Colin P Kelly Jr St 6 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9630 72480 4 9 42X Colin P Kelly Jr St 3 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9633 75872 4 9 42X Colin P Kelly Jr St 1 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9718 105047 4 37 278 Capitol Ave   1 1 1       3x3   5995102.4 2087946.7 37.7128233663074 -122.458788296392 (37.7128233663074, -122.458788296392)
9761 122592 4 96 72 Townsend St 1 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9764 122593 4 9 72 Townsend St 2 1 1 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
Powered by Datasette · Query took 3.005ms · Data source: data.sfgov.org