sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
54 121137 4 26 1388x Minna St 1 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
56 27602 1 26 988 Fulton St 2 1 1 1     20 4X4   6003218.3377 2111393.5053 37.7776659856505 -122.432410615738 (37.7776659856505, -122.432410615738)
60 121139 4 26 1388x Minna St 3 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
70 121138 4 26 1388x Minna St 2 1 1 1   09/08/2016 12:00:00 AM 3 3x3            
97 5266 3 26 1245 Divisadero St 2 1 1 2     12 3X4   6001289.7409 2112772.8314 37.781343716873 -122.43918115910401 (37.781343716873, -122.439181159104)
98 142074 2 26 1384X GROVE ST 2 1 1 1     5 Width 0ft   6001183.1648 2110763.0502 37.7758193019084 -122.439405751925 (37.7758193019084, -122.439405751925)
102 98037 5 26 1384X Grove St 1 1 1 1   03/23/2017 12:00:00 AM 3   Permit Number 767782 6001197.2582 2110764.9293 37.775825263482105 -122.439357134105 (37.7758252634821, -122.439357134105)
107 142075 2 26 1384X GROVE ST 3 1 1 1     8 Width 0ft   6001166.7226 2110758.8221 37.775806756879895 -122.439462326391 (37.7758067568799, -122.439462326391)
115 6964 1 26 700 Fell St 2 1 1 1     8 3X3   6003997.6735 2110460.7643 37.7751490695403 -122.42964808764499 (37.7751490695403, -122.429648087645)
153 5972 3 26 1550 Eddy St 1 1 1 2   02/02/1990 12:00:00 AM 8 3X3   6003044.0843 2112751.363 37.7813844410266 -122.43311045884899 (37.7813844410266, -122.433110458849)
234 26932 3 26 1570 Golden Gate Ave 1 1 1 2   04/05/2000 12:00:00 AM 3 3X3   6002097.1307 2111930.5841 37.7790770280177 -122.43632769328998 (37.7790770280177, -122.43632769329)
264 20199 3 26 1300X Steiner St 7 1 1 2   01/02/1991 12:00:00 AM 12 3X3   6002784.1975 2112923.5771 37.7818425521761 -122.434021853774 (37.7818425521761, -122.434021853774)
309 20164 3 26 1155X Steiner St 3 1 1 2   12/31/1990 12:00:00 AM 25 4X4   6002621.0 2112212.0 37.7798794773869 -122.43453554599199 (37.7798794773869, -122.434535545992)
322 7968 1 26 1901 Franklin St 3 1 1 1   10/03/2007 12:00:00 AM 3 3X3   6005627.24821 2116610.0246200003 37.7921255585096 -122.42444850412 (37.7921255585096, -122.42444850412)
329 5267 3 26 1245 Divisadero St 3 1 1 2     6 3X4   6001292.1098 2112753.8798 37.7812918154006 -122.43917160516001 (37.7812918154006, -122.43917160516)
337 14819 3 26 1234 McAllister St 5 1 1 2     12 4X4   6003219.5071 2111735.2352 37.7786043572111 -122.432430984172 (37.7786043572111, -122.432430984172)
347 250073 4 26 1599X Bush St 2 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
373 250075 4 26 1599X Bush St 4 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
377 250072 4 26 1599X Bush St 1 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
386 2602 1 26 1760 Bush St 1 1 1 1     6 3X3   6005112.3923 2115130.7833 37.7880348455319 -122.42612455857201 (37.7880348455319, -122.426124558572)
414 17191 1 26 1804X Bush St 2 1 1 1     10 4X4   6004806.1465 2115088.0891 37.7879003042654 -122.427181073064 (37.7879003042654, -122.427181073064)
415 250074 4 26 1599X Bush St 3 1 1 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
442 9602 1 26 1355 Golden Gate Ave 4 1 1 1     11 3X3   6003083.4108 2112017.0963 37.779370559175206 -122.432921935155 (37.7793705591752, -122.432921935155)
452 221749 2 26 275 Grattan St 3 1 2 1     24 Width 4ft   5997432.91763 2106413.5715 37.763662611962 -122.452064861225 (37.763662611962, -122.452064861225)
458 221750 2 26 275 Grattan St 2 1 2 1     11 Width 4ft   5997409.41415 2106414.31665 37.7636633116224 -122.45214620578699 (37.7636633116224, -122.452146205787)
463 234072 3 26 1400 San Bruno Ave 2 1 1 4 4   4 Width 3ft   6011140.67766 2101759.7310900004 37.7516598624171 -122.404326151746 (37.7516598624171, -122.404326151746)
472 236059 2 26 601X 14th St 3 1 1 1     16 Width 3ft   6004719.95486 2107769.51353 37.7678004187701 -122.42695783742799 (37.7678004187701, -122.426957837428)
483 236058 2 26 601X 14th St 2 1 1 1     13 Width 3ft   6004683.7857099995 2107762.8709299997 37.767780134560205 -122.427082469082 (37.7677801345602, -122.427082469082)
491 236057 2 26 601X 14th St 1 1 1 1     15 Width 3ft   6004642.9908 2107763.18347 37.767778685763 -122.427223596101 (37.767778685763, -122.427223596101)
496 245474 2 26 275 Grattan St 1 1 2 1     19 Width 4ft   5997377.53226 2106405.56262 37.7636374489232 -122.452255843041 (37.7636374489232, -122.452255843041)
510 7848 1 26 885 Franklin St 4 1 1 1     3 4X4   6006120.7355 2113033.04101 37.7823319018231 -122.422486748168 (37.7823319018231, -122.422486748168)
577 15499 1 26 2704 Mission St 3 1 1 1     12 3X3   6006991.0 2102555.0 37.7536107294676 -122.41873270043001 (37.7536107294676, -122.41873270043)
590 98625 3 26 3500X Fillmore St 4 1 1 4 2   6 3x3   6002285.2374 2120040.8430000003 37.8013564005351 -122.43625752618999 (37.8013564005351, -122.43625752619)
615 2703 1 26 2123 Bush St 1 1 1 1   02/06/1987 12:00:00 AM 12 3X3   6003147.2203 2114799.0941 37.7870128441602 -122.432899995096 (37.7870128441602, -122.432899995096)
616 8142 3 26 924 Fulton St 2 1 1 2     35 3X3   6003320.2078 2111406.4501 37.777707304798206 -122.432059137251 (37.7777073047982, -122.432059137251)
630 20157 1 26 1100X Steiner St 2 1 1 3     18 4X4   6002895.0285 2112125.5503 37.7796576600117 -122.433581380876 (37.7796576600117, -122.433581380876)
653 144739 2 26 510 22nd Ave 1 1 1 1     0 Width 3ft   5989096.969740001 2111833.32857 37.7780627562405 -122.481292881664 (37.7780627562405, -122.481292881664)
655 251353 2 26 510 22nd Ave 4 1 1 1       Width 3ft   5989096.969740001 2111833.32857 37.7780627562405 -122.481292881664 (37.7780627562405, -122.481292881664)
658 147406 2 26 515 22nd Ave 1 1 1 1     0 6x10   5989054.53583 2111789.60329 37.7779402316839 -122.48143647103201 (37.7779402316839, -122.481436471032)
871 20198 3 26 1300X Steiner St 6 1 1 2   01/02/1991 12:00:00 AM 12 3X3   6002788.752 2112893.404 37.7817599629104 -122.43400393984501 (37.7817599629104, -122.434003939845)
913 107355 2 26 2001 Grant Ave 3 1 1 1     14 3x3   6010310.1611 2121354.7321 37.8054166971664 -122.40858034027201 (37.8054166971664, -122.408580340272)
957 141829 3 26 1058 GOLDEN GATE AVE 1 1 1 2     5 Width 0ft   6004468.2701 2112261.9634 37.780121354581105 -122.42814858004101 (37.7801213545811, -122.428148580041)
992 7205 1 26 926 Fillmore St 4 1 1 1   12/05/2001 12:00:00 AM 3 4X4   6003464.8493 2111545.8007 37.778098126187295 -122.431568724094 (37.7780981261873, -122.431568724094)
1000 133103 2 26 2401 Larkin St 2 1 1 1     8 Width 3ft   6006658.0 2119469.0 37.8000337406718 -122.42108517312599 (37.8000337406718, -122.421085173126)
1019 5195 1 26 625 Divisadero St 1 1 1 1   06/29/2007 12:00:00 AM 3 3X3   6001591.0229 2110593.2492 37.7753762735578 -122.437982704394 (37.7753762735578, -122.437982704394)
1089 9603 1 26 1355 Golden Gate Ave 5 1 1 1     11 3X3   6003102.1679 2112019.7759 37.7793789805584 -122.43285723801 (37.7793789805584, -122.43285723801)
1096 211742 2 26 700 Junipero Serra Blvd 88 1 1 1     8 Width 0ft   5991230.19236 2092152.91218 37.724149261961706 -122.472478226094 (37.7241492619617, -122.472478226094)
1110 14853 3 26 1351 McAllister St 1 1 1 2   12/15/2005 12:00:00 AM 3 3x3   6002697.0103 2111613.4514 37.778240327396105 -122.434229790526 (37.7782403273961, -122.434229790526)
1142 20178 3 26 1200X Steiner St 7 1 1 2   01/02/1991 12:00:00 AM 6 3X3   6002826.2747 2112615.9016 37.781000140452704 -122.433854288088 (37.7810001404527, -122.433854288088)
1159 112361 6 26 561X Folsom St 1 7 1 1   11/16/2015 12:00:00 AM 3 10x30 Permit Number 775828 6013749.7362 2114198.9064599997 37.785960521430205 -122.396175324952 (37.7859605214302, -122.396175324952)
1229 235065 1 26 2400 Diamond St 3 1 1 1   07/29/1997 12:00:00 AM 6 Width 2ft Permit Number 38465 6001951.69941 2097144.86437 37.7384707551305 -122.43577263420299 (37.7384707551305, -122.435772634203)
1236 9417 3 26 700X Golden Gate Ave 6 1 1 2   12/11/1997 12:00:00 AM 6 4X4   6006077.70084 2112484.44584 37.7808231658948 -122.422596633642 (37.7808231658948, -122.422596633642)
1255 65778 1 26 3101 Scott St 1 1 1 1 1 04/23/1990 12:00:00 AM 5   Permit Number 28743 6000913.14979 2119077.92932 37.7986344413927 -122.440936428972 (37.7986344413927, -122.440936428972)
1268 221739 3 26 960 Stanyan St 1 1 1 2     18 Width 3ft   5997261.09109 2107110.0824 37.7655652095945 -122.452709425124 (37.7655652095945, -122.452709425124)
1300 14826 1 26 1269 McAllister St 1 1 1 1     6 4X4   6003119.6747 2111677.9775 37.7784414803533 -122.432772251133 (37.7784414803533, -122.432772251133)
1314 92967 1 26 3022 Clay St 1 1 1 1   11/23/2016 12:00:00 AM 3 4x4 Permit Number 779165 6000091.47375 2115801.73595 37.7895920459934 -122.443544210206 (37.7895920459934, -122.443544210206)
1328 236115 1 26 410 Waller St 1 1 1 1   12/15/1992 12:00:00 AM 6 Width 3ft Permit Number 780066 6003708.0 2109045.0 37.771245321662896 -122.4305490898 (37.7712453216629, -122.4305490898)
1331 14830 3 26 1284 McAllister St 1 1 1 2     12 6x6   6003046.0718 2111709.6378 37.778524236985895 -122.433029133637 (37.7785242369859, -122.433029133637)
1339 66377 1 26 621 Fillmore St 1 1 1 1 1 01/04/1991 12:00:00 AM 12   Permit Number 29502 6003558.1677 2110522.6128 37.775293994216 -122.431172851087 (37.775293994216, -122.431172851087)
1351 5208 3 26 802 Divisadero St 1 1 1 2     12 2X3   6001567.0603 2111230.6559 37.777125069374705 -122.438111266341 (37.7771250693747, -122.438111266341)
1361 16698 3 26 950X Noriega St 2 11 2 2     12 8   5991017.9677099995 2103156.31666 37.7543495107367 -122.47401428523999 (37.7543495107367, -122.47401428524)
1400 235284 3 26 4235 19th St 3 1 1 4   03/07/1990 12:00:00 AM 11 Width 3ft   6001885.77275 2104671.54401 37.7591334867264 -122.43653915428499 (37.7591334867264, -122.436539154285)
1446 139885 1 26 1575 TURK ST 3 1 1 1   04/23/1990 12:00:00 AM 6 Width 0ft   6002581.4123 2112293.0339 37.7800997287845 -122.434678293337 (37.7800997287845, -122.434678293337)
1449 234076 3 26 1400 San Bruno Ave 7 1 1 4     12 Width 4ft   6011147.1312 2101589.6307 37.751193164657 -122.40429186329901 (37.751193164657, -122.404291863299)
1454 234074 3 26 1400 San Bruno Ave 4 1 1 4     11 Width 3ft   6011143.5049 2101689.8522900003 37.751468148541996 -122.40431145682301 (37.751468148542, -122.404311456823)
1456 139884 1 26 1585 TURK ST 5 1 1 1   04/23/1990 12:00:00 AM 4 Width 0ft   6002525.5727 2112285.5886 37.7800761156462 -122.43487093500299 (37.7800761156462, -122.434870935003)
1461 234073 3 26 1400 San Bruno Ave 3 1 1 4     17 Width 3ft   6011143.13167 2101723.71293 37.7515611015794 -122.404315130536 (37.7515611015794, -122.404315130536)
1464 234075 3 26 1400 San Bruno Ave 6 1 1 4     14 Width 4ft   6011146.17896 2101629.85029 37.75130354562771 -122.404297986789 (37.7513035456277, -122.404297986789)
1474 139883 1 26 1585 TURK ST 4 1 1 1     5 Width 0ft   6002506.9595 2112283.5581 37.780069483595 -122.434935181147 (37.780069483595, -122.434935181147)
1476 139882 1 26 1585 TURK ST 3 1 1 1   04/23/1990 12:00:00 AM 14 Width 0ft   6002483.27 2112280.1738 37.780058846079605 -122.435016891621 (37.7800588460796, -122.435016891621)
1481 51149 1 26 1600X North Point St 2 1 1 1   07/28/2004 12:00:00 AM 3 3x3 Permit Number 47562 6003023.69355 2121013.0550700002 37.804067769267704 -122.433771669621 (37.8040677692677, -122.433771669621)
1572 9622 1 26 1404 Golden Gate Ave 1 1 1 1     6 3X3   6002793.2644 2112026.6959 37.7793804561129 -122.433926358604 (37.7793804561129, -122.433926358604)
1589 45715 1 26 475 Hampshire St 1 1 1 1   05/24/2017 12:00:00 AM 3   Permit Number 44386 6010097.78481 2106045.52558 37.7633693601423 -122.40823487245301 (37.7633693601423, -122.408234872453)
1667 251648 2 26 2649 Mission St 1 1 1 1       3x3   6007031.0 2102934.0 37.7546536287073 -122.41862124555 (37.7546536287073, -122.41862124555)
1672 251649 2 26 2649 Mission St 2 1 1 1       3x3   6007031.0 2102934.0 37.7546536287073 -122.41862124555 (37.7546536287073, -122.41862124555)
1704 251429 2 26 1345 Noe St 1 1 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779991 6003307.0 2100429.0 37.7475651236724 -122.43132102920099 (37.7475651236724, -122.431321029201)
1714 115408 2 26 889 North Point St 1 1 1 1     2 3x3   6006526.39743 2121457.3012099997 37.8054856898732 -122.42168186931801 (37.8054856898732, -122.421681869318)
1724 14824 3 26 1234 McAllister St 10 1 1 2     12 4X4   6003110.3265 2111720.6082 37.7785580034409 -122.43280763628599 (37.7785580034409, -122.432807636286)
1744 9601 3 26 1355 Golden Gate Ave 3 1 1 2     10 3X3   6003062.4207 2112013.0769 37.7793583323419 -122.432994261414 (37.7793583323419, -122.432994261414)
1816 20201 1 26 1300X Steiner St 9 1 1 1   01/02/1991 12:00:00 AM 12 3X3   6002775.658 2112980.5073 37.7819983835402 -122.43405546728 (37.7819983835402, -122.43405546728)
1821 21741 3 26 2045 Sutter St 5 1 1 2     12 4X4   6002908.4575 2114420.548 37.7859599074732 -122.433698994827 (37.7859599074732, -122.433698994827)
1845 98642 3 26 3500X Fillmore St 21 1 1 4 2   10 3x3   6002233.86885 2120387.2869599997 37.8023047257379 -122.436460093962 (37.8023047257379, -122.436460093962)
1887 20008 3 26 100 STAIRWAY46 28 1 1 2     3 2            
1910 18873 1 26 2299 Sacramento St 2 1 1 1     12 3X3   6003870.98343 2115955.49438 37.790229051088 -122.430478480014 (37.790229051088, -122.430478480014)
1922 14822 3 26 1234 McAllister St 8 1 1 2     12 4X4   6003155.2525 2111726.3545 37.778576329265 -122.432652630798 (37.778576329265, -122.432652630798)
1931 135812 1 26 1147 Filbert St 2 1 1 1   04/05/2017 12:00:00 AM 3 3x3 Permit Number 779607 6007418.27175 2119501.50723 37.800165825864205 -122.418456642358 (37.8001658258642, -122.418456642358)
1968 251132 1 26 354 05th St 2 1 1 1 4 02/11/2006 12:00:00 AM   3x3 Permit Number 779305 6011875.0 2111882.0 37.779494345884295 -122.402498458881 (37.7794943458843, -122.402498458881)
1986 251131 3 26 354 05th St 1 1 1 2 3 02/14/2014 12:00:00 AM   3x3 Permit Number 779305 6011875.0 2111882.0 37.779494345884295 -122.402498458881 (37.7794943458843, -122.402498458881)
2036 11448 3 26 2X Arguello Blvd 2 1 1 2   06/19/2017 12:09:00 PM 3 3   5995519.82754 2115841.84115 37.789440378559796 -122.45936442896799 (37.7894403785598, -122.459364428968)
2044 20173 3 26 1200X Steiner St 2 1 1 2   01/02/1991 12:00:00 AM 6 3X3   6002849.1714 2112441.6535 37.780522998189795 -122.43376261941201 (37.7805229981898, -122.433762619412)
2129 156905 4 26 3201x 17th St 1 1 1 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
2130 18891 3 26 2513 Sacramento St 1 1 1 2   08/01/1990 12:00:00 AM 8 3X3   6002620.56709 2115777.954 37.7896706584215 -122.434792120457 (37.7896706584215, -122.434792120457)
2133 252909 4 26 3201x 17th St 2 1 1 1   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417.0 2106083.0 37.763321780718705 -122.417509514421 (37.7633217807187, -122.417509514421)
2142 252906 4 26 600 South Van Ness Ave 2 1 1 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2143 252905 4 26 600 South Van Ness Ave 1 1 1 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2147 252908 4 26 600 South Van Ness Ave 3 1 1 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2181 98628 3 26 3500X Fillmore St 7 1 1 4 2   6 3x4   6002274.71062 2120096.76485 37.801509349129795 -122.43629795788999 (37.8015093491298, -122.43629795789)
2243 20174 3 26 1200X Steiner St 3 1 1 2   01/02/1991 12:00:00 AM 6 3X3   6002845.6787 2112476.9688 37.7806197669525 -122.433777227143 (37.7806197669525, -122.433777227143)
2368 68207 1 26 2048 Stockton St 1 1 1 1 1 08/26/1995 12:00:00 AM 10   Permit Number 31989 6009891.7858 2121179.0457 37.80491086613029 -122.41001577934601 (37.8049108661303, -122.410015779346)
2375 14825 3 26 1234 McAllister St 11 1 1 2     12 4X4   6003082.6395 2111715.9066 37.7785435236875 -122.432903080133 (37.7785435236875, -122.432903080133)
2418 235026 1 26 541 Douglass St 1 1 1 1   03/22/1991 12:00:00 AM 7 Width 3ft Permit Number 29690 6001207.084969999 2103119.58489 37.7548335932981 -122.43877516473499 (37.7548335932981, -122.438775164735)
Powered by Datasette · Query took 2.812ms · Data source: data.sfgov.org