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)
1012 246499 2 35 311 Duncan St 1 1 1 1   04/27/2017 12:00:00 AM 3 Width 3ft Permit Number 779776 6004393.833380001 2099835.13521 37.7459960419019 -122.427520522551 (37.7459960419019, -122.427520522551)
1259 238460 2 35 52 Pierce St 1 1 1 1   05/08/2017 12:00:00 AM 3 Width 3ft Permit Number 779768 6002902.99046 2108581.89909 37.7699281239255 -122.433300551682 (37.7699281239255, -122.433300551682)
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)
1998 135937 1 35 98 Spruce St 6 1 1 1   06/14/2017 12:00:00 AM 3 3x3 Permit Number 780098 5997052.02369 2116054.59656 37.7901125223289 -122.45407860247299 (37.7901125223289, -122.454078602473)
2000 237999 1 35 4302 24th St 1 1 1 1   12/27/2012 12:00:00 AM 2 Width 4ft Permit Number 769743 6001218.46057 2101752.36044 37.7510801711245 -122.438637864349 (37.7510801711245, -122.438637864349)
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)
3013 39333 1 35 0 21st St 3 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
3043 244994 1 35 231 Lily St 1 1 1 1   05/02/2002 12:00:00 AM 4 Width 0ft Permit Number 45013 6005396.3109 2110099.8972 37.774237312156295 -122.4247842062 (37.7742373121563, -122.4247842062)
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)
3195 253357 1 35 1705 Buchanan St 5 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)
3197 253348 1 35 1728 Buchanan St 1 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)
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)
3200 253352 1 35 1756 Buchanan St 4 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)
3205 253356 1 35 1705 Buchanan St 4 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)
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)
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)
3217 253347 1 35 1700 Buchanan St 5 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)
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)
3224 253358 1 35 1715 Buchanan St 1 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)
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)
3226 138479 1 35 1700 Buchanan St 1 1 1 1   11/26/2003 12:00:00 AM 2 Width 0ft Permit Number 47204 6004045.5542 2114285.9086 37.7856546769882 -122.429755345095 (37.7856546769882, -122.429755345095)
3229 253353 1 35 1705 Buchanan St 1 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)
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)
3236 253349 1 35 1756 Buchanan St 1 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)
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)
3242 253354 1 35 1705 Buchanan St 2 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)
3244 253350 1 35 1756 Buchanan St 2 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)
3245 138485 1 35 1700 Buchanan St 2 1 1 1   11/26/2003 12:00:00 AM 2 Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3246 253346 1 35 1700 Buchanan St 4 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)
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)
4409 114730 1 35 2536 Clay St 1 1 1 1   10/11/2017 12:00:00 AM 3 3x3 Permit Number 780830 6002593.47602 2116148.5251 37.790686613557504 -122.43491236523899 (37.7906866135575, -122.434912365239)
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)
5373 31852 1 35 1117 Houston St 2 1 1 1   06/19/1995 12:00:00 AM     Permit Number 35299          
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)
5518 39334 1 35 0 21st St 4 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
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)
6740 39332 1 35 0 21st St 2 1 1 1   12/21/1998 12:00:00 AM     Permit Number 40897          
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)
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)
Powered by Datasette · Query took 2.734ms · Data source: data.sfgov.org