sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
131 237033 3 18 100 Octavia St 7 4 1 2     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079)
135 237030 3 18 100 Octavia St 4 4 1 2     5 Width 4ft   6005725.94025 2109733.85532 37.773250861665204 -122.423617927146 (37.7732508616652, -122.423617927146)
158 21682 3 35 1830 Sutter St 1 1 1 2   03/28/2017 12:00:00 AM 3 4x4   6003825.2217 2114604.0634 37.7865157709252 -122.43054034167 (37.7865157709252, -122.43054034167)
182 93463 3 57 1739 Taraval St 1 1 1 2   03/28/2017 01:05:00 PM 3 3x3   5987772.1588 2098929.0107 37.7425539090053 -122.48492886712098 (37.7425539090053, -122.484928867121)
213 28640 3 35 1300 Webster St 2 11 1 2   04/21/2008 12:00:00 AM 3 20   6003714.7015 2113244.5448 37.782776612799296 -122.430825656777 (37.7827766127993, -122.430825656777)
343 244298 3 35 350 Octavia St 1 1 1 2     6 Width 0ft   6005605.7628 2110511.5277 37.7753793775331 -122.42408895277501 (37.7753793775331, -122.424088952775)
368 18096 3 35 3008 Pine St 1 1 1 2   01/29/1997 12:00:00 AM 6 3X3   5999424.6928 2114682.6521 37.786481285230295 -122.44577068023099 (37.7864812852303, -122.445770680231)
605 23903 3 35 1600X Webster St 6 11 1 2     3 6   6003560.4697 2114360.5617 37.7858321751093 -122.431438928251 (37.7858321751093, -122.431438928251)
853 244350 3 35 300 Octavia St 5 1 1 2   04/20/2017 07:22:00 AM 3 Width 0ft   6005619.219 2110418.7508 37.77512539438639 -122.424035805431 (37.7751253943864, -122.424035805431)
1311 237352 2 18 3186 Cesar Chavez St 2 1 1 2     7 4x4   6008549.69387 2100618.49329 37.7483811527756 -122.413205447889 (37.7483811527756, -122.413205447889)
1535 28642 3 16 1300 Webster St 4 11 1 2     10 20   6003705.0759 2113297.4854 37.782921429068395 -122.430862736641 (37.7829214290684, -122.430862736641)
2141 18982 3 18 2920 Sacramento St 1 1 1 2     12 3X3   6000616.67404 2115546.70514 37.7889217363036 -122.44170876675699 (37.7889217363036, -122.441708766757)
2489 119760 3 35 101X Octavia St Frontage West 2 1 1 2       4x4            
2492 119762 3 35 101X Octavia St Frontage West 4 1 1 2       4x4            
2501 119761 3 35 101X Octavia St Frontage West 3 1 1 2       4x4            
2508 119759 3 35 101X Octavia St Frontage West 1 1 1 2       4x4            
2513 138183 3 35 1865 Buchanan St 3 1 1 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003936.4381 2114774.6580000003 37.7869904804487 -122.43016773530199 (37.7869904804487, -122.430167735302)
2541 138182 3 35 1865 Buchanan St 2 1 1 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003933.6106 2114790.6807 37.7870343146011 -122.43017866131201 (37.7870343146011, -122.430178661312)
2544 138181 3 35 1865 Buchanan St 1 1 1 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003932.1968 2114801.9909 37.7870652894849 -122.43018435992599 (37.7870652894849, -122.430184359926)
2550 138186 3 35 1865 Buchanan St 6 1 1 2     2 Width 0ft   6003941.622 2114719.9923 37.786840675810396 -122.43014589889499 (37.7868406758104, -122.430145898895)
2555 138187 3 16 1865 Buchanan St 7 1 1 2   02/18/1998 12:00:00 AM 6 Width 0ft   6003949.1621 2114685.5907 37.7867466447295 -122.43011735683599 (37.7867466447295, -122.430117356836)
2581 107490 3 84 1306x Montgomery St 19 11 1 2     12     6011447.18476 2119974.7633599997 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963)
3019 20034 3 16 100 STAIRWAY51 5 1 1 2     3 ST            
3403 19880 3 198 100 STAIRWAY33 12 1 1 2     6 25ST            
3513 247938 4 16 29 Joy St 1 14 1 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
3951 20035 3 16 100 STAIRWAY51 6 1 1 2     3 ST            
4106 20001 3 198 100 STAIRWAY46 21 1 1 2     6 2            
4125 135979 3 18 99 Fern St 2 1 1 2   11/01/2009 12:00:00 AM 4 Width 4ft   6006900.63841 2115164.21663 37.788227554109504 -122.419939904112 (37.7882275541095, -122.419939904112)
4128 135978 3 18 99 Fern St 1 1 1 2   11/01/2009 12:00:00 AM 4 Width 4ft   6006877.42 2115159.3392 37.788212853775896 -122.420019889812 (37.7882128537759, -122.420019889812)
4250 139410 3 35 1500 GEARY BLVD 10 1 1 2   10/10/2017 10:27:00 AM 3 Width 0ft   6004177.291 2114035.4814 37.78497452552379 -122.429281709952 (37.7849745255238, -122.429281709952)
4309 1910 3 35 47 Beideman St 2 1 1 2     6 3X3   6001514.9606 2113070.1349 37.782172849750296 -122.43842331734601 (37.7821728497503, -122.438423317346)
4328 28085 3 18 2255 Bush St 2 1 1 2     6 3x3   6002770.4091 2114749.1272 37.786854268374796 -122.43420010239201 (37.7868542683748, -122.434200102392)
4329 239457 4 18 165 Sussex St 2 1 1 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437)
4331 87404 3 35 1300 Webster St 9 11 1 2   04/21/2008 12:00:00 AM 3 3x3   6003683.0746 2113412.9921 37.783237334948105 -122.43094709822701 (37.7832373349481, -122.430947098227)
4404 239458 4 18 165 Sussex St 3 1 1 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029)
4516 28647 3 35 1600X Webster St 9 11 1 2     8 6   6003547.8453 2114380.4001 37.785885930849204 -122.431484021877 (37.7858859308492, -122.431484021877)
4797 214559 3 18 1342 Irving St 1 2 1 2   02/18/2009 12:00:00 AM 3 Width 3ft   5991532.56497 2106606.32246 37.7638521099028 -122.472486197695 (37.7638521099028, -122.472486197695)
4821 214558 3 18 1340 Irving St 1 2 1 2   02/18/2009 12:00:00 AM 4 Width 3ft   5991564.93185 2106609.34919 37.7638622938456 -122.472374472204 (37.7638622938456, -122.472374472204)
5254 253839 3 16 94 Cortland Ave 1 1 1 2       3x3   6006239.0 2097690.0 37.740210176126794 -122.42098789234 (37.7402101761268, -122.42098789234)
5350 28646 3 35 1600X Webster St 8 11 1 2     8 6   6003557.7645 2114374.9896 37.7858716371659 -122.431449317827 (37.7858716371659, -122.431449317827)
5494 87738 3 18 3200X Van Ness Ave 10 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005444.64461 2121623.98788 37.8058823097966 -122.425437295217 (37.8058823097966, -122.425437295217)
5542 8104 3 35 780 Fulton St 1 1 1 2   12/04/2010 12:00:00 AM 3 3X3   6004088.9733 2111516.0342 37.7780517500412 -122.429407531137 (37.7780517500412, -122.429407531137)
5618 87403 3 35 1300 Webster St 8 11 1 2   04/21/2008 12:00:00 AM 10 3x3   6003687.1999 2113392.3659 37.7831809343135 -122.430931353807 (37.7831809343135, -122.430931353807)
5843 8073 3 133 664 Fulton St 1 1 1 2     30 3X3   6004507.0606 2111574.6856 37.77823645397079 -122.42796539753 (37.7782364539708, -122.42796539753)
5957 28643 3 35 1300 Webster St 5 11 1 2     10 20   6003700.2631 2113325.6745 37.7829985565916 -122.43088139933201 (37.7829985565916, -122.430881399332)
5993 23902 3 35 1600X Webster St 5 11 1 2     8 20   6003560.0188 2114334.411 37.7857603463241 -122.431438620741 (37.7857603463241, -122.431438620741)
6439 2463 3 16 1826 Buchanan St 2 1 1 2   07/23/1997 12:00:00 AM 3 4X4   6003987.7732 2114755.2881 37.7869402029829 -122.429988745219 (37.7869402029829, -122.429988745219)
6475 23884 3 35 1750X Geary Blvd 1 1 1 2     3 3X3   6003258.4682 2113929.8349 37.7846323872704 -122.432452992684 (37.7846323872704, -122.432452992684)
6496 23490 3 35 2500X Van Ness Ave 6 11 1 2     30 9   6005777.87956 2119177.1307599996 37.799182688783496 -122.424109961515 (37.7991826887835, -122.424109961515)
6573 19697 3 84 100 STAIRWAY9 1 1 1 2     3 15ST            
6617 103761 3 18 106X Austin St 3 1 1 2   11/01/2009 12:00:00 AM 3 3x3   6006685.575019999 2115508.13748 37.7891597571573 -122.42070841348101 (37.7891597571573, -122.420708413481)
6792 23871 3 35 1499X Webster St 4 1 1 2     12 3X3   6003600.3539 2113692.9201 37.784001259600295 -122.43125326646499 (37.7840012596003, -122.431253266465)
6925 2462 3 16 1826 Buchanan St 1 1 1 2   02/17/1998 12:00:00 AM 3 4X4   6003992.7724 2114732.7916 37.78687871637621 -122.429969843785 (37.7868787163762, -122.429969843785)
7067 28641 3 35 1300 Webster St 3 11 1 2     8 20   6003709.2011 2113267.9212 37.7828404869024 -122.43084635463 (37.7828404869024, -122.43084635463)
7138 29119 3 18 509 Ellis St 1 1 1 2   11/19/2005 12:00:00 AM 3 3x3   6008381.9659 2113792.89597 37.7845455839642 -122.414717657915 (37.7845455839642, -122.414717657915)
7408 19027 3 16 3170 Sacramento St 1 1 1 2     12 2x2   5999630.40201 2115407.06556 37.7884820784247 -122.44511107923 (37.7884820784247, -122.44511107923)
7475 28644 3 35 1300 Webster St 6 11 1 2   04/21/2008 12:00:00 AM 3 20   6003694.7628 2113348.3634 37.7830605429851 -122.430902047868 (37.7830605429851, -122.430902047868)
7527 20039 3 16 100 STAIRWAY51 10 1 1 2     3 ST            
7662 88451 3 18 3200X Van Ness Ave 1 11 1 2   06/07/2008 12:00:00 AM 3 5x12   6005480.84439 2121378.35155 37.805209901088396 -122.425294529632 (37.8052099010884, -122.425294529632)
7952 17354 3 18 2200 Franklin St 1 1 1 2     3 3X3   6005542.87933 2117567.08542 37.7947486417029 -122.424808539584 (37.7947486417029, -122.424808539584)
8439 19025 3 16 3170 Sacramento St 4 5 1 2     8 2X2   5999621.132119999 2115414.4338700003 37.7885017807754 -122.445143681435 (37.7885017807754, -122.445143681435)
8518 18226 3 35 1675 Post St 3 1 1 2     12 3X3   6004172.0667 2114245.454 37.785550761919 -122.42931476245899 (37.785550761919, -122.429314762459)
8595 28648 3 35 1600X Webster St 10 11 1 2   04/21/2008 12:00:00 AM 3 6   6003548.747 2114394.8281 37.7859255976047 -122.43148193261601 (37.7859255976047, -122.431481932616)
8626 87739 3 18 3200X Van Ness Ave 11 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005433.618530001 2121623.41722 37.8058801199389 -122.42547541206699 (37.8058801199389, -122.425475412067)
8858 21651 3 18 1689 Sutter St 1 1 1 2   10/31/2013 12:00:00 AM 3 4X4   6004532.1578 2114645.7829 37.7866703442988 -122.428097491401 (37.7866703442988, -122.428097491401)
8873 8201 3 16 1360 Fulton St 1 1 1 2     30 3X3   6001243.6294 2111120.8056 37.7768050488635 -122.439222237812 (37.7768050488635, -122.439222237812)
8875 2624 3 18 1822 Bush St 1 1 1 2     6 3X3   6004615.6699 2115060.0567 37.7878125608959 -122.427838089219 (37.7878125608959, -122.427838089219)
9027 21627 3 35 1615 Sutter St 1 1 1 2 3 10/14/2010 12:00:00 AM 6 4X4 Permit Number 53778 6004639.3671 2114660.2794 37.7867162131248 -122.42772760613701 (37.7867162131248, -122.427727606137)
9515 19958 3 84 100 STAIRWAY40 3 1 1 2     3 15ST            
9526 14741 3 16 900 Pierce St 1 1 1 2     12 4X4   6002478.8616 2111661.3163 37.7783593683998 -122.434987870066 (37.7783593683998, -122.434987870066)
9562 19696 3 84 100 STAIRWAY9 -3 1 1 2     12 15ST            
9608 16823 3 16 2139X O'Farrell St 3 1 1 2     6 4X4   6001040.8337 2113118.4303 37.7822784765294 -122.440067043321 (37.7822784765294, -122.440067043321)
9842 12410 3 35 1610X Laguna St 1 1 1 2   09/13/1989 12:00:00 AM 7 4X4   6004460.5933 2114341.7023 37.78583136591 -122.42832340690398 (37.78583136591, -122.428323406904)
9845 12411 3 35 1610X Laguna St 2 1 1 2   09/13/1989 12:00:00 AM 6 4X4   6004443.6433 2114336.5232 37.785816186279504 -122.42838167990801 (37.7858161862795, -122.428381679908)
9984 106984 3 35 1737-1795 Post St 5 1 1 2   04/01/2012 12:00:00 AM 3     6003775.6189 2114189.0991 37.7853735733153 -122.430682332536 (37.7853735733153, -122.430682332536)
10080 10041 3 16 360 Guerrero St 4 1 1 2   02/02/1991 12:00:00 AM 20 3X3   6005475.31081 2106892.46038 37.765434922114295 -122.42428276264299 (37.7654349221143, -122.424282762643)
10132 18098 3 35 3016 Pine St 1 1 1 2   01/31/2017 11:58:00 AM 3     5999364.6601 2114676.4418 37.7864608055495 -122.445977930803 (37.7864608055495, -122.445977930803)
10293 86369 3 35 1281 26th Ave 1 1 1 2   12/20/2006 12:00:00 AM 3 3x3   5987992.2676 2106611.2343 37.7636600473858 -122.484731221945 (37.7636600473858, -122.484731221945)
10326 86251 3 35 2230 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988566.0868 2100132.7531 37.7459052793749 -122.48227190373699 (37.7459052793749, -122.482271903737)
10332 86580 3 35 2539 27th Ave 1 1 1 2   01/05/2007 12:00:00 AM 3 3x3   5987975.8922 2098002.1559 37.740020874126394 -122.484156469463 (37.7400208741264, -122.484156469463)
10336 86256 3 35 1754 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988460.2167 2103365.3979 37.75477510171329 -122.482874855725 (37.7547751017133, -122.482874855725)
10350 86577 3 35 2519 27th Ave 1 1 1 2   01/05/2007 12:00:00 AM 3 3x3   5987971.7931 2098127.9672 37.740366080244 -122.484179866453 (37.740366080244, -122.484179866453)
10357 85931 3 35 1686 26th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988131.3934 2103830.0344 37.756031730146 -122.48404607344901 (37.756031730146, -122.484046073449)
10374 85990 3 35 2234 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987638.7841 2100062.768 37.7456591364178 -122.485473213008 (37.7456591364178, -122.485473213008)
10377 28246 3 18 3326 San Bruno Ave 1 1 1 2   02/23/2002 12:00:00 AM 3 2X3   6011947.80562 2090200.17318 37.7199648154144 -122.400722979282 (37.7199648154144, -122.400722979282)
10379 86560 3 35 1887 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 6 3x3   5987821.2541 2102469.8936 37.7522790893532 -122.48501883929899 (37.7522790893532, -122.485018839299)
10398 93419 3 117 1904 Taraval St 1 1 1 2   02/19/2015 03:04:00 PM 3 3x3   5987281.1088 2098978.4203 37.7426609609829 -122.486630378914 (37.7426609609829, -122.486630378914)
10407 85987 3 35 2286 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987649.8793 2099748.6884 37.744797403731106 -122.485411804387 (37.7447974037311, -122.485411804387)
10410 86450 3 35 2362 27th Ave 1 1 1 2   12/29/2006 12:00:00 AM 3 3x3   5987982.1495 2099214.8079 37.7433508614418 -122.4842237451 (37.7433508614418, -122.4842237451)
10411 93420 3 57 2002 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986956.2239 2098967.2524 37.742611352251004 -122.48775290190399 (37.742611352251, -122.487752901904)
10421 86100 3 35 2628 24th Ave 1 1 1 2   01/16/2007 12:00:00 AM 3 3x3   5988972.7801 2097431.8111 37.738512846904996 -122.48066793928899 (37.738512846905, -122.480667939289)
10444 86261 3 35 1726 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988455.289 2103558.6714 37.7553054920736 -122.482906060899 (37.7553054920736, -122.482906060899)
10450 86208 3 35 2447 24th Ave 1 1 1 2   01/19/2007 12:00:00 AM 3 3x3   5988885.905 2098662.6727 37.741887422325 -122.48105840788601 (37.741887422325, -122.481058407886)
10452 86308 3 35 1503 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988358.1168 2105058.904 37.7594190709864 -122.48335207735599 (37.7594190709864, -122.483352077356)
10454 86246 3 35 2292X 25th Ave 1 1 1 2   12/21/2006 12:00:00 AM 3 3x3   5988581.0227 2099729.0585 37.744797709288605 -122.48219068753401 (37.7447977092886, -122.482190687534)
10462 86574 3 35 2435 27th Ave 1 1 1 2   01/05/2007 12:00:00 AM 3 3x3   5987950.8455 2098721.8965 37.74199563410829 -122.484295842204 (37.7419956341083, -122.484295842204)
10464 86111 3 35 2544 24th Ave 2 1 1 2   01/17/2007 12:00:00 AM 3 3x3   5988952.3483 2098011.286 37.7401027466921 -122.48078099378901 (37.7401027466921, -122.480780993789)
10467 86008 3 35 1726 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987525.9378 2103513.8062 37.7551281853344 -122.48611670118099 (37.7551281853344, -122.486116701181)
10469 86571 3 35 2401X 27th Ave 1 1 1 2   01/05/2007 12:00:00 AM 3 3x3   5987947.4613 2098914.797 37.7425250909553 -122.484321687901 (37.7425250909553, -122.484321687901)
10486 86247 3 35 2290 25th Ave 1 1 1 2   12/21/2006 12:00:00 AM 3 3x3   5988579.3157 2099752.9558 37.744863225687105 -122.482198340398 (37.7448632256871, -122.482198340398)
10487 86204 3 35 2427 24th Ave 1 1 1 2   01/19/2007 12:00:00 AM 3 3x3   5988880.8286 2098804.4715 37.7422764696275 -122.48108634060499 (37.7422764696275, -122.481086340605)
Powered by Datasette · Query took 11.086ms · Data source: data.sfgov.org