sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
92 98091 3 35 2X Frank Norris St 4 1 1 4 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
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)
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)
426 21683 1 35 1840 Sutter St 1 1 1 1   08/03/1999 12:00:00 AM 6 2x2   6003770.0848 2114594.6383 37.786486768354294 -122.430730428794 (37.7864867683543, -122.430730428794)
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)
1472 244877 2 35 1349 Page St 1 1 1 1     15 Width 0ft   6000105.0 2109153.0 37.7713370947812 -122.443019734512 (37.7713370947812, -122.443019734512)
2427 23895 1 35 1581 Webster St 2 1 1 1   03/30/2006 12:00:00 AM 3 3X3   6003532.7108 2114115.4269999997 37.7851575236987 -122.431517459739 (37.7851575236987, -122.431517459739)
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)
2613 98090 3 35 2X Frank Norris St 3 1 1 4 2   3 3x3   6007144.43128 2115568.9527 37.7893525915946 -122.419125139911 (37.7893525915946, -122.419125139911)
2665 21684 1 35 1840 Sutter St 2 1 1 1   04/09/2004 12:00:00 AM 3 4x4   6003739.9244 2114585.2131 37.7864591803505 -122.43083410335501 (37.7864591803505, -122.430834103355)
3194 253362 1 35 1737 Buchanan St 2 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3199 253365 1 35 1745 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3209 253364 1 35 1741 Buchanan St 2 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3215 253360 1 35 1723 Buchanan St 2 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3218 139416 2 35 1701 POST ST 1 1 1 1   04/01/2014 12:00:00 AM 3 Width 0ft   6004006.3401 2114230.9234 37.7855014808051 -122.429887091087 (37.7855014808051, -122.429887091087)
3221 253361 1 35 1737 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3234 253359 1 35 1723 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3238 253363 1 35 1741 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3398 245004 2 35 1201 Page St 2 1 1 1     6 Width 0ft   6000727.3724 2109263.3505 37.7716755548589 -122.44087484303499 (37.7716755548589, -122.440874843035)
3528 13088 1 35 722 Lombard St 1 1 1 1     45 3X3   6008925.6016 2120449.3844 37.802853199751794 -122.413307745784 (37.8028531997518, -122.413307745784)
3617 196400 2 35 380x Clara St 2 1 1 1     1 Width 2ft   6011308.09655 2111275.91215 37.7777985048225 -122.404416956276 (37.7777985048225, -122.404416956276)
4145 113403 2 35 2052 Polk St 1 1 1 1     4 3x3   6006463.2485 2117908.2188 37.7957372487994 -122.42164817262501 (37.7957372487994, -122.421648172625)
4166 143128 2 35 2052 POLK ST 2 1 1 1     4 Width 0ft   6006467.2287 2117887.8753 37.795681615093 -122.421632954779 (37.795681615093, -122.421632954779)
4179 23894 1 35 1581 Webster St 1 1 1 1   10/10/2017 09:37:00 AM 3 3X3   6003529.5219 2114142.2135 37.7852308919409 -122.431530405312 (37.7852308919409, -122.431530405312)
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)
4281 139414 2 35 1500 GEARY BLVD 14 1 1 1   10/10/2017 10:29:00 AM 3 Width 0ft   6004053.5092 2114020.2427 37.7849256755107 -122.42970886814301 (37.7849256755107, -122.429708868143)
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)
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)
4504 8092 1 35 762 Fulton St 3 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004291.3267 2111546.8391 37.778147787093 -122.428709714706 (37.778147787093, -122.428709714706)
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)
4753 98088 3 35 2X Frank Norris St 1 1 1 4 2   3 3x3   6007178.15894 2115574.08384 37.7893685797349 -122.41900880992901 (37.7893685797349, -122.419008809929)
5269 8090 1 35 762 Fulton St 1 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004349.2473 2111557.1689 37.7781794280627 -122.428510082803 (37.7781794280627, -122.428510082803)
5333 26937 1 35 1529 Golden Gate Ave 2 1 1 1     3 3X3   6002019.9705 2111862.8998 37.7788867994939 -122.436589775324 (37.7788867994939, -122.436589775324)
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)
5466 21688 1 35 1881 Sutter St 3 1 1 1   05/19/1992 12:00:00 AM 2 4x4   6003696.9634 2114537.7544 37.7863264365495 -122.430979349218 (37.7863264365495, -122.430979349218)
5536 8091 1 35 762 Fulton St 2 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004317.1512 2111553.1108 37.7781664691559 -122.42862082556499 (37.7781664691559, -122.428620825565)
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)
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)
5979 98098 2 35 81 Frank Norris St 4 1 1 1     3 3x3   6006897.32558 2115510.94052 37.789179385771604 -122.41997598040399 (37.7891793857716, -122.419975980404)
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)
6039 23898 1 35 1581 Webster St 5 1 1 1   03/30/2006 12:00:00 AM 3 3X3   6003553.1196 2113987.2345 37.7848066960652 -122.43143769715701 (37.7848066960652, -122.431437697157)
6273 106722 2 35 2905 Bush St 1 1 1 1     5 3x3   5999550.4676 2114295.9601 37.7854267102234 -122.44530771900499 (37.7854267102234, -122.445307719005)
6354 98096 2 35 81 Frank Norris St 2 1 1 1     3 3x3   6006843.26628 2115504.44745 37.789158511592 -122.420162558272 (37.789158511592, -122.420162558272)
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)
6750 21685 1 35 1840 Sutter St 3 1 1 1   08/03/1999 12:00:00 AM 6 4x4   6003694.6838 2114582.3856 37.7864488534059 -122.43099042257299 (37.7864488534059, -122.430990422573)
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)
6874 13090 1 35 724 Lombard St 1 1 1 1   02/26/2004 12:00:00 AM 12 3X3   6008885.9219 2120447.4555 37.8028456756355 -122.413444921903 (37.8028456756355, -122.413444921903)
6947 26936 1 35 1529 Golden Gate Ave 1 1 1 1     3 3X3   6002004.7416 2111860.8692 37.7788803585551 -122.436642312661 (37.7788803585551, -122.436642312661)
7053 23897 1 35 1581 Webster St 4 1 1 1   03/30/2006 12:00:00 AM 3 3X3   6003549.9307 2114010.8321 37.784871308404 -122.431450414863 (37.784871308404, -122.431450414863)
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)
7387 98089 3 35 2X Frank Norris St 2 1 1 4 2   3 3x3   6007160.90241 2115572.1732 37.789362361841505 -122.41906838009899 (37.7893623618415, -122.419068380099)
7425 8168 1 35 1160 Fulton St 1 1 1 1     35 3X3   6002214.9627 2111253.4218 37.7772244047313 -122.435871600468 (37.7772244047313, -122.435871600468)
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)
7481 21730 1 35 1955 Sutter St 1 1 1 1   04/25/1990 12:00:00 AM 6 3X3   6003249.1628 2114463.8768 37.786098203806205 -122.43252334451599 (37.7860982038062, -122.432523344516)
7927 13089 1 35 722 Lombard St 2 1 1 1     60 3X3   6008909.0684 2120447.731 37.8028477316821 -122.41336484235 (37.8028477316821, -122.41336484235)
8037 12253 1 35 528 Laguna St 1 1 1 1   06/02/2003 12:00:00 AM 6 3x3   6005030.2517 2110722.9994 37.7759275170107 -122.426094839447 (37.7759275170107, -122.426094839447)
8106 114661 2 35 1603 Laguna St 2 1 1 1   10/27/2016 12:00:00 AM 3 3x3   6004477.5231 2114370.1159 37.7859103404926 -122.42826686028299 (37.7859103404926, -122.428266860283)
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)
8560 98097 2 35 81 Frank Norris St 3 1 1 1     3 3x3   6006875.6654 2115508.14993 37.789170503156704 -122.420050723983 (37.7891705031567, -122.420050723983)
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)
8638 98095 2 35 81 Frank Norris St 1 1 1 1     3 3x3   6006820.270769999 2115499.9051599996 37.789144743881295 -122.420241797518 (37.7891447438813, -122.420241797518)
8790 105143 2 35 432 Octavia St 1 1 1 3 2   3 4x4   6005556.0703 2110851.1612 37.776309122873705 -122.42428501193301 (37.7763091228737, -122.424285011933)
9626 173611 2 35 3779 25th St 1 1 1 1     7 3x3   6005304.0 2101328.0 37.7501465436699 -122.424479453971 (37.7501465436699, -122.424479453971)
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)
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)
10144 173880 2 35 1922 Grove St 1 1 1 1       3x3   5998581.0 2110425.0 37.7747426714218 -122.448382913575 (37.7747426714218, -122.448382913575)
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)
10354 95012 1 35 107 Leland Ave 1 1 1 1   06/12/1998 12:00:00 AM 3 3x3   6010407.8674 2087313.2581 37.7119519253908 -122.40584279071301 (37.7119519253908, -122.405842790713)
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)
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)
10400 94994 1 35 82 Leland Ave 1 1 1 1     3 3x3   6010574.5301 2087274.9346 37.7118560160688 -122.405264057289 (37.7118560160688, -122.405264057289)
10403 95015 1 35 83 Leland Ave 1 1 1 1     3     6010521.9467 2087254.8816 37.711798014587295 -122.40544438972 (37.7117980145873, -122.40544438972)
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)
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)
10438 95023 1 35 45 Leland Ave 2 1 1 1     3 3x3   6010750.3281 2087136.1233 37.711484695229295 -122.404646681546 (37.7114846952293, -122.404646681546)
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)
10461 92319 6 35 2788 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509)
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)
Powered by Datasette · Query took 10.969ms · Data source: data.sfgov.org