sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
79328 88522 1 35 10 Valdez Ave   1 1 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51454 5996417.0 2093827.6 37.7290464055545 -122.45466924520201 (37.7290464055545, -122.454669245202)
79469 88223 1 35 2442 Fulton St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51219 5996404.0 2110432.0 37.7746371856421 -122.455914062335 (37.7746371856421, -122.455914062335)
79787 96460 1 35 2001 Market St   5 1 1   05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
80163 88235 1 35 329 Lyon St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51224 6000219.0 2110006.0 37.773685716624705 -122.44268666247 (37.7736857166247, -122.44268666247)
83825 96459 1 35 2001 Market St   5 1 1   05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
84888 88277 1 35 103 Aptos Ave   1 1 1   07/09/2008 12:00:00 AM   3x3 Permit Number 51270 5993062.0 2093861.6 37.7289467548913 -122.46627011422899 (37.7289467548913, -122.466270114229)
85137 88093 1 35 1726 39th Ave   1 1 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51097 5984135.0 2103400.2 37.7546180463975 -122.497834981734 (37.7546180463975, -122.497834981734)
90531 96463 1 35 2001 Market St   5 1 1   05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
91694 88359 1 35 1443 12th Ave   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51337 5992382.4 2105622.1 37.7611988469011 -122.46947525322099 (37.7611988469011, -122.469475253221)
93473 88253 1 35 1025 Ashbury St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51238 5999131.0 2106547.0 37.7641260948648 -122.446201344399 (37.7641260948648, -122.446201344399)
94809 89293 1 35 1353 26th Ave   1 1 1   10/23/2008 12:00:00 AM   3x3 Permit Number 51899 5987992.1 2106076.8 37.7621926272889 -122.484692595652 (37.7621926272889, -122.484692595652)
98303 96462 1 35 2001 Market St   5 1 1   05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
99390 87844 1 35 536 28th Ave   1 1 1   06/09/2008 12:00:00 AM   3x3 Permit Number 50751 5987246.0 2112270.7 37.7791558680057 -122.487728106826 (37.7791558680057, -122.487728106826)
101288 88731 1 35 248 Scott St   1 1 1   08/11/2008 12:00:00 AM   3x3 Permit Number 51665 6002314.0 2109330.0 37.771948792814 -122.435391376972 (37.771948792814, -122.435391376972)
102251 88260 1 35 123 Corbett Ave   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51245 6000668.3 2105609.4 37.7616393503242 -122.44081702139401 (37.7616393503242, -122.440817021394)
110626 96461 1 35 2001 Market St   5 1 1   05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
113743 88226 1 35 2108 Hayes St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51222 5997802.0 2109918.0 37.7733060118428 -122.451041052194 (37.7733060118428, -122.451041052194)
117193 88594 1 35 298 Divisadero St   1 1 1   07/31/2008 12:00:00 AM   3x3 Permit Number 51540 6001881.0 2109400.2 37.7721169442044 -122.436894179858 (37.7721169442044, -122.436894179858)
120326 89001 1 35 212 Maynard St   1 1 1   09/25/2008 12:00:00 AM   3x3 Permit Number 51753 6004786.0 2093771.0 37.7293674698939 -122.425732914897 (37.7293674698939, -122.425732914897)
120728 88189 1 35 123 Dore St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51194 6009069.0 2109644.0 37.7731922763614 -122.41204743866301 (37.7731922763614, -122.412047438663)
122629 88131 1 35 525 Jersey St   1 1 1   07/03/2008 12:00:00 AM   3x3 Permit Number 51155 6001754.0 2101449.0 37.750277666491606 -122.436764203777 (37.7502776664916, -122.436764203777)
123530 88091 1 35 1619 39th Ave   1 1 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51095 5984024.3 2104125.3 37.756602478656 -122.498271356488 (37.756602478656, -122.498271356488)
123599 88648 1 35 74 Carmelita St   1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51628 6002619.0 2108775.0 37.7704422164895 -122.434296675208 (37.7704422164895, -122.434296675208)
123951 88225 1 35 2084 Hayes St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51221 5997896.9 2109991.0 37.7735118836843 -122.450718045928 (37.7735118836843, -122.450718045928)
124580 88278 1 35 103 Aptos Ave   1 1 1   07/09/2008 12:00:00 AM   3x3 Permit Number 51270 5993062.0 2093861.6 37.7289467548913 -122.46627011422899 (37.7289467548913, -122.466270114229)
143890 88505 1 35 140 Colon Ave   1 1 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51443 5996179.5 2093971.6 37.7294281696535 -122.455500699897 (37.7294281696535, -122.455500699897)
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)
Powered by Datasette · Query took 26.342ms · Data source: data.sfgov.org