sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
1905 251810 2 11 2 Hangah St 3 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1912 251809 2 11 2 Hangah St 2 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1919 251807 2 160 2 Hangah St 1 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1921 251811 2 11 2 Hangah St 4 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1923 251813 2 160 2 Hangah St 6 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7764 103662 2 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
9748 173655 3 78 100 Lawton St 1 11 1 10                    
9751 173659 3 78 200 Lawton St 1 11 1 10           5993693.06683 2104628.21116 37.7585455452803 -122.46487007071998 (37.7585455452803, -122.46487007072)
10665 103665 2 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11212 103658 6 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11415 103667 2 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12113 103660 6 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12885 103661 6 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
15949 103659 6 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
19689 99005 3 11 2099X Beach St 4 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
37389 95036 3 43 3224 Pierce St 7 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
62496 103654 6 17 307X Octavia St 3 7 1 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
77610 109992 2 55 501X Shotwell St 9 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
79502 98996 3 12 2190X North Point St 2 1 1 10   04/18/2011 12:00:00 AM   3x3   6000702.0 2120685.0 37.803035002067396 -122.441782472194 (37.8030350020674, -122.441782472194)
81348 113709 2 39 2801x CLEMENT ST 5 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
81659 113874 2 11 301x BRODERICK ST 11 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
82710 99003 3 11 2099X Beach St 2 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
82784 95034 3 43 3224 Pierce St 3 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
83793 95035 3 43 3224 Pierce St 5 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
83876 109990 2 26 501X Shotwell St 7 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
84126 95033 3 43 3224 Pierce St 1 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
84481 113708 2 39 2801x CLEMENT ST 4 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
85949 109996 2 55 501X Shotwell St 13 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
86889 111133 2 62 2030x HAYES ST 6 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
88973 113868 2 11 301x BRODERICK ST 5 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
89354 111589 3 47 730X Lake Merced Blvd 5 7 1 10 4       Permit Number 774260 5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
89691 109988 2 26 501X Shotwell St 5 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
89824 110738 6 333 1299x PERSIA AVE 5 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
90177 109991 2 297 501X Shotwell St 8 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
90304 113871 2 11 301x BRODERICK ST 8 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
91879 95040 3 43 3224 Pierce St 13 5 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
92640 109986 2 26 501X Shotwell St 3 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
93134 98908 2 26 501X Shotwell St 2 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
94016 99008 3 11 2099X Beach St 7 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
94908 95038 3 43 3224 Pierce St 9 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
94914 99004 3 11 2099X Beach St 3 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
94965 99002 3 11 2190X North Point St 8 1 1 10   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
95046 109987 2 26 501X Shotwell St 4 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
95213 113810 2 51 4101x 25TH ST 3 1 1 10 6     3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
95919 113866 2 11 301x BRODERICK ST 3 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
96054 99000 3 11 2190X North Point St 6 1 1 10   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
98122 103656 6 17 307X Octavia St 5 7 1 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
99848 110538 2 17 100X ASHBURY ST 6 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
100981 103655 6 17 307X Octavia St 4 7 1 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
101830 113867 2 11 301x BRODERICK ST 4 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
104170 110739 6 333 1299x PERSIA AVE 6 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
104559 114737 2 225 455x LILY ST 1 10 1 10 4         6004484.0 2109981.0 37.77385927942 -122.427931581119 (37.77385927942, -122.427931581119)
104986 95041 3 43 3224 Pierce St 12 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
106116 109995 2 55 501X Shotwell St 12 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
108162 95039 3 43 3224 Pierce St 11 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
108397 113873 2 11 301x BRODERICK ST 10 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
108530 110402 2 19 419X 18TH AVE 3 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
109029 108973 7 3 3485X SAN BRUNO AVE 1 3 1 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
109505 111134 2 62 2030x HAYES ST 7 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
109915 109999 2 10 501X Shotwell St 16 1 1 10 4         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
110121 49668 3 11 2099X Beach St 1 1 1 10 3 04/18/2011 12:00:00 AM     Permit Number 46510 6000239.54014865 2120711.44405841 37.8030812490195 -122.44338472026199 (37.8030812490195, -122.443384720262)
111553 113706 2 39 2801x CLEMENT ST 2 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
114359 98998 3 11 2190X North Point St 4 1 1 10   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
115106 95044 3 43 3224 Pierce St 6 5 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
115140 98795 3 25 950@Washington Clay St 7 1 1 10       3x3 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
115219 98995 3 12 2190X Divisadero St 1 1 1 10       3x3   6000922.9 2115860.7 37.7898013277865 -122.44067180053001 (37.7898013277865, -122.44067180053)
115629 113707 2 39 2801x CLEMENT ST 3 1 1 10 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
115819 110406 2 19 419X 18TH AVE 7 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
116544 113872 2 11 301x BRODERICK ST 9 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
117615 113869 2 11 301x BRODERICK ST 6 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
118334 111131 2 62 2030x HAYES ST 4 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
120277 99001 3 11 2190X North Point St 7 1 1 10   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
120466 99006 3 11 2099X Beach St 5 1 1 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
121059 103652 6 17 307X Octavia St 1 7 1 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
121101 110540 2 22 100X ASHBURY ST 8 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
121169 109989 2 26 501X Shotwell St 6 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
123900 98997 3 11 2190X North Point St 3 1 1 10       3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
124070 98909 2 26 501X Shotwell St 1 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
124316 109993 2 55 501X Shotwell St 10 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
125272 110420 2 20 419X 18TH AVE 18 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
125443 110737 6 333 1299x PERSIA AVE 4 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
125707 110537 2 17 100X ASHBURY ST 5 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
125996 103653 6 17 307X Octavia St 2 7 1 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
126528 111776 2 62 2030x HAYES ST 9 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
126853 110533 2 11 100X ASHBURY ST 1 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
127158 98799 3 44 950@Washington Clay St 1 1 1 10   03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
128369 109998 2 10 501X Shotwell St 15 1 1 10 4         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
140201 111132 2 62 2030x HAYES ST 5 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
142174 111129 2 62 2030x HAYES ST 2 1 1 10 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
142889 109994 2 55 501X Shotwell St 11 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
143072 97216 3 36 300X Claremont Blvd 3 16 1 10           5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
144577 113865 2 11 301x BRODERICK ST 2 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
144668 110414 2 19 419X 18TH AVE 15 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
144922 110534 2 22 100X ASHBURY ST 2 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
106701 113812 2 51 4101x 25TH ST 5 1 1 10 6   1 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
178704 98797 3 44 950@Washington Clay St 8 1 1 10   03/16/2012 12:00:00 AM 1 3x3 Permit Number 768771 6010116.35805 2117191.91562 37.793975769724796 -122.408957127878 (37.7939757697248, -122.408957127878)
Powered by Datasette · Query took 3.661ms · Data source: data.sfgov.org