sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
2508 119759 3 35 101X Octavia St Frontage West 1 1 1 2       4x4            
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
9942 34361 1 35 1838 Church St 1 1 1 1 1 01/11/2017 12:00:00 AM 3   Permit Number 779412 6004552.33920365 2098065.78752592 37.7411467825752 -122.42684644404301 (37.7411467825752, -122.426846444043)
9949 63390 1 35 725 Andover St 1 1 1 1 1 01/12/2017 12:00:00 AM 3   Permit Number 779370 6007403.5343153 2095452.62499742 37.734132412410396 -122.416802921773 (37.7341324124104, -122.416802921773)
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)
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)
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)
10493 86399 3 35 1639 26th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988077.0028 2104128.4671 37.75684797893629 -122.484256057823 (37.7568479789363, -122.484256057823)
10502 86009 3 35 1722 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987523.9067 2103537.3673 37.755192759360106 -122.486125454711 (37.7551927593601, -122.486125454711)
10514 86262 3 35 1722 25th Ave 1 1 1 2   12/12/2006 12:00:00 AM 3 3x3   5988454.7415 2103581.1196 37.7553670969368 -122.48290959942499 (37.7553670969368, -122.482909599425)
10519 86446 3 35 2426 27th Ave 1 1 1 2   12/29/2006 12:00:00 AM 3 3x3   5987996.8709 2098757.0924 37.742094952584296 -122.484139283552 (37.7420949525843, -122.484139283552)
10546 86231 3 35 2426 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988617.0288 2098793.8112 37.7422318603031 -122.481997687782 (37.7422318603031, -122.481997687782)
10547 85949 3 35 1430 26th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988070.6928 2105557.2008 37.760770526422206 -122.484382665437 (37.7607705264222, -122.484382665437)
10559 26794 1 35 186 Leland Ave 1 1 1 1   08/09/1999 12:00:00 AM 2 3x3   6010044.3489 2087538.0893 37.7125489295627 -122.407115057358 (37.7125489295627, -122.407115057358)
10586 85951 3 35 1390 26th Ave 1 1 1 2   12/21/2006 12:00:00 AM 3 3x3   5988061.1772 2105842.3097 37.7615528036389 -122.484436487246 (37.7615528036389, -122.484436487246)
10592 26788 1 35 78 Leland Ave 1 1 1 1   08/06/1999 12:00:00 AM 4 3X3   6010596.3656 2087261.1203 37.711819305554 -122.40518761518801 (37.711819305554, -122.405187615188)
10610 86583 3 35 2567 27th Ave 1 1 1 2   01/05/2007 12:00:00 AM 3 3x3   5987981.2526 2097846.7049 37.7395943585814 -122.48412653866998 (37.7395943585814, -122.48412653867)
10612 93470 3 35 1445 Taraval St 1 1 1 2   02/26/2009 12:00:00 AM 3 3x3   5988675.4994 2098958.5529 37.7426875982526 -122.48180758126699 (37.7426875982526, -122.481807581267)
10616 86106 3 35 2576 24th Ave 1 1 1 2   01/17/2007 12:00:00 AM 3 3x3   5988959.241 2097817.0609999998 37.7395698560466 -122.480742946483 (37.7395698560466, -122.480742946483)
10619 86004 3 35 1774 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987534.4685 2103215.2309 37.7543088755282 -122.486065283877 (37.7543088755282, -122.486065283877)
10664 85932 3 35 1666 26th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988126.3838 2103953.8446 37.7563713878607 -122.48407247701599 (37.7563713878607, -122.484072477016)
10668 108896 1 35 312 Allison St 1 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772786 6000205.0169 2087170.16849 37.7109831566161 -122.441096373403 (37.7109831566161, -122.441096373403)
10700 86253 3 35 2206 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988562.6729 2100280.8313 37.746311664404395 -122.482294555654 (37.7463116644044, -122.482294555654)
10702 86368 3 35 1235 26th Ave 1 1 1 2   12/20/2006 12:00:00 AM 3 3x3   5987981.927999999 2106870.8736 37.764372343527704 -122.48478603091999 (37.7643723435277, -122.48478603092)
10703 86119 3 35 2462 24th Ave 1 1 1 2   01/17/2007 12:00:00 AM 3 3x3   5988932.9456 2098582.1283 37.7416690029042 -122.480889862999 (37.7416690029042, -122.480889862999)
10712 85954 3 35 1370 26th Ave 1 1 1 2   12/21/2006 12:00:00 AM 3 3x3   5988057.3894 2105986.2433 37.7619477854522 -122.484460144927 (37.7619477854522, -122.484460144927)
10713 86573 3 35 2423 27th Ave 1 1 1 2   01/05/2007 12:00:00 AM 3 3x3   5987947.4613 2098798.3799 37.742205440307295 -122.48431315163401 (37.7422054403073, -122.484313151634)
10735 95001 1 35 166 Leland Ave 1 1 1 1     3 3x3   6010153.2106 2087493.0431 37.712431333442 -122.40673562308099 (37.712431333442, -122.406735623081)
10736 86002 3 35 1824 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987543.255 2102835.2262 37.7532659973414 -122.486007006329 (37.7532659973414, -122.486007006329)
10737 85944 3 35 1530 26th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988094.8611 2104879.1908 37.758910302597705 -122.48424935350799 (37.7589103025977, -122.484249353508)
10738 86398 3 35 1631 26th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988074.1402 2104179.9951 37.75698929420739 -122.484269736563 (37.7569892942074, -122.484269736563)
10754 86066 3 35 1959 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987532.0381 2101952.375 37.7508412720312 -122.48598099746 (37.7508412720312, -122.48598099746)
10766 109710 1 35 274 Trumbull St 1 1 1 1 1 03/02/2015 12:00:00 AM 3 3x3 Permit Number 774419 6005156.44986 2094314.59165 37.730880978857 -122.42449088466101 (37.730880978857, -122.424490884661)
10767 86061 3 35 1877 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987508.8564 2102515.9989 37.752387480581206 -122.48610253041201 (37.7523874805812, -122.486102530412)
10772 86206 3 35 2439 24th Ave 1 1 1 2   01/19/2007 12:00:00 AM 3 3x3   5988884.8897 2098711.7439 37.742022099983295 -122.481065510643 (37.7420220999833, -122.481065510643)
10775 93460 3 35 1855X Taraval St 1 1 1 2   02/26/2009 12:00:00 AM 3 3x3   5987430.6912 2098918.5196 37.7425052083655 -122.486108776631 (37.7425052083655, -122.486108776631)
10788 94995 1 35 88 Leland Ave 1 1 1 1     3 3x3   6010547.3472 2087288.7489 37.711892427555796 -122.40535898167299 (37.7118924275558, -122.405358981673)
10790 80073 6 35 2788 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3     5985889.2586 2096432.3825 37.735588983385 -122.49125558617901 (37.735588983385, -122.491255586179)
10806 86097 3 35 2646 24th Ave 1 1 1 2   01/16/2007 12:00:00 AM 3 3x3   5988975.9803 2097328.4213 37.7382291513586 -122.480649308029 (37.7382291513586, -122.480649308029)
10823 86395 3 35 1609 26th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988071.9932 2104313.1089 37.7573546636623 -122.48428692393 (37.7573546636623, -122.48428692393)
10825 85998 3 35 1848 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987552.182999999 2102681.5677 37.752844612846395 -122.485964853879 (37.7528446128464, -122.485964853879)
Powered by Datasette · Query took 2.612ms · Data source: data.sfgov.org