sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14 196590 4 9 43 Lafayette St 2 4 1 1     10 Width 3ft Permit Number 772992 6007565.6944699995 2109618.27361 37.773037177355796 -122.41724576098301 (37.7730371773558, -122.417245760983)
15 196591 4 9 43 Lafayette St 3 4 1 1     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782)
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)
30 196592 4 9 43 Lafayette St 4 4 1 1     8 Width 3ft Permit Number 772992 6007533.59843 2109642.31042 37.7731013709756 -122.41735848920901 (37.7731013709756, -122.417358489209)
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            
138 72565 4 44 270 Brannan St 1 5 1 1   11/16/1996 12:00:00 AM 3 4x4 Permit Number 770847 6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
139 116640 4 44 270 Brannan St 2 5 1 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
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)
347 250073 4 26 1599X Bush St 2 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
350 85805 4 6 210X Shipley St 1 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627.0 2111882.0 37.77948049775679 -122.40335640121799 (37.7794804977568, -122.403356401218)
351 251213 4 6 210X Shipley St 6 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
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)
365 251211 4 6 210X Shipley St 4 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
369 192563 4 11 33 08th St 1 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.777668779422896 -122.413273679445 (37.7776687794229, -122.413273679445)
372 251291 4 11 33 08th St 5 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
373 250075 4 26 1599X Bush St 4 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
377 250072 4 26 1599X Bush St 1 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
384 85806 4 6 210X Shipley St 2 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627.0 2111882.0 37.77948049775679 -122.40335640121799 (37.7794804977568, -122.403356401218)
387 85807 4 6 210X Shipley St 3 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
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)
395 249557 4 11 1450 Franklin St 3 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005881.27559 2115126.52616 37.788066583556706 -122.423464052238 (37.7880665835567, -122.423464052238)
396 251212 4 6 210X Shipley St 5 1 1 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
400 251289 4 11 33 08th St 3 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
403 65940 4 62 620 Eddy St 1 1 1 1 1 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.78332336932171 -122.41797588370702 (37.7833233693217, -122.417975883707)
404 249555 4 11 1450 Franklin St 1 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005893.0868 2115064.96247 37.787898211588704 -122.423418809148 (37.7878982115887, -122.423418809148)
406 249556 4 11 1450 Franklin St 2 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005884.0832400005 2115105.79396 37.7880098165527 -122.423452863778 (37.7880098165527, -122.423452863778)
412 251290 4 11 33 08th St 4 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
413 249558 4 11 1450 Franklin St 4 4 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005877.98213 2115146.79048 37.7881220384566 -122.42347688825899 (37.7881220384566, -122.423476888259)
415 250074 4 26 1599X Bush St 3 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
416 192564 4 11 33 08th St 2 1 1 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
425 251299 4 15 2190X Market St 3 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
431 251298 4 15 2190X Market St 4 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
432 251297 4 15 2190X Market St 5 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
446 251296 4 15 2190X Market St 2 1 1 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
451 192346 4 83 118 10th St 1 1 1 1   04/09/2014 12:00:00 AM 1 Width 3ft Permit Number 770901 6007994.19176 2110350.5452799997 37.7750719195804 -122.41581539288201 (37.7750719195804, -122.415815392882)
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)
721 183636 4 108 1478 47th Ave 1 2 1 1     4 3x9   5981570.9282 2105017.3718 37.7589076903569 -122.506822015648 (37.7589076903569, -122.506822015648)
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)
1388 251519 4 11 173 Sanchez St 2 1 1 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1395 251525 4 46 173 Sanchez St 8 1 1 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1401 251523 4 11 173 Sanchez St 6 1 1 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1406 14313 4 125 2190X Market St 7 1 1 2   05/01/2017 12:00:00 AM 3 4X4 Permit Number 779911 6003603.86 2107219.9092 37.7662281664546 -122.43077904924299 (37.7662281664546, -122.430779049243)
1413 246406 4 11 173 Sanchez St 1 1 1 1     16 3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1414 251524 4 11 173 Sanchez St 7 1 1 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1416 251521 4 11 173 Sanchez St 4 1 1 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1425 251522 4 11 173 Sanchez St 5 1 1 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1432 14312 4 125 2190X Market St 6 1 1 2   05/01/2017 12:00:00 AM 3 4X4 Permit Number 779911 6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
1433 251520 4 11 173 Sanchez St 3 1 1 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
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)
1601 102430 4 75 200 06th St 2 1 1 1   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010566.09371 2111909.33227 37.779496235110706 -122.407028471514 (37.7794962351107, -122.407028471514)
1602 102429 4 75 200 06th St 1 1 1 1   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010552.49087 2111923.99595 37.7795357369219 -122.40707656363399 (37.7795357369219, -122.407076563634)
1634 199504 4 75 1009 Howard St 2 1 1 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010510.13491 2111932.18806 37.7795558601644 -122.407223669342 (37.7795558601644, -122.407223669342)
1642 199503 4 75 1009 Howard St 1 1 1 1   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010500.983080001 2111924.50305 37.7795342467397 -122.40725478770099 (37.7795342467397, -122.407254787701)
1801 251699 4 11 1230 Chestnut St 3 1 1 1 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6005943.79297 2120373.7363400003 37.8024776288704 -122.423620966152 (37.8024776288704, -122.423620966152)
1809 172747 4 11 1230 Chestnut St 2 1 1 1 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006022.78943 2120387.12776 37.802518857014704 -122.423348551388 (37.8025188570147, -122.423348551388)
1812 172746 4 11 1230 Chestnut St 1 1 1 1 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006038.86692 2120389.38612 37.8025259652646 -122.423293075825 (37.8025259652646, -122.423293075825)
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)
2129 156905 4 26 3201x 17th St 1 1 1 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
2133 252909 4 26 3201x 17th St 2 1 1 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
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)
2257 229627 4 21 3662 Folsom St 1 1 1 1     1 Width 3ft   6008456.11159 2097816.22885 37.7406815009641 -122.41333091228701 (37.7406815009641, -122.413330912287)
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)
2687 253164 4 17 146 Cambridge St 1 8 1 1   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.4119099998 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225)
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)
2811 115532 4 106 100X Hayes St 2 10 1 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007293.46404 2111265.83422 37.777545665835596 -122.41830427922501 (37.7775456658356, -122.418304279225)
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)
3174 253344 4 88 2586 30th Ave 1 1 1 1   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945)
3179 253343 4 26 200 Arguello Blvd 3 1 1 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
3189 253342 4 26 200 Arguello Blvd 2 1 1 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
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)
Powered by Datasette · Query took 2.303ms · Data source: data.sfgov.org