sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1043 81845 3 12 1421 Pine St 2 1 1 10 6 04/28/2017 08:33:00 AM 3 3x3 Permit Number 50020 6007103.87391 2115697.8037 37.789704100621705 -122.419274608151 (37.7897041006217, -122.419274608151)
1586 98725 3 15 360 Grove St 1 1 1 10     14 3x3   6006216.75471 2111460.37935 37.7780191723707 -122.42204280683501 (37.7780191723707, -122.422042806835)
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)
2825 81846 3 12 1421 Pine St 1 1 1 10 6 12/20/2007 12:00:00 AM 3 3x3 Permit Number 50020 6007049.49584 2115692.06976 37.7896852939829 -122.419462344328 (37.7896852939829, -122.419462344328)
2933 98726 3 15 360 Grove St 2 1 1 10     12 3x3   6006198.51355 2111464.4034 37.7780291926159 -122.422106195562 (37.7780291926159, -122.422106195562)
3428 98728 3 15 360 Grove St 4 1 1 10     14 3x3   6006156.19882 2111456.14926 37.778004142027 -122.42225199096 (37.778004142027, -122.42225199096)
6003 98729 3 15 360 Grove St 5 1 1 10     13 3x3   6006140.89781 2111454.63858 37.7779991309825 -122.42230481531901 (37.7779991309825, -122.422304815319)
6064 98727 3 15 360 Grove St 3 1 1 10     12 3x3   6006176.94483 2111455.11485 37.7780024719703 -122.422180149508 (37.7780024719703, -122.422180149508)
9030 98730 3 15 360 Grove St 6 1 1 10     13 3x3   6006126.244940001 2111454.93961 37.777999130991205 -122.42235552627899 (37.7779991309912, -122.422355526279)
37389 95036 3 43 3224 Pierce St 7 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
43480 111380 2 3 301x OCEAN AVE 2 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
44837 95043 3 43 3224 Pierce St 4 5 1 10     9 3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
51360 110401 2 36 419X 18th Ave 2 1 1 10 10   27 3x3   5990271.90904 2112469.3758 37.779877404965504 -122.4772748837 (37.7798774049655, -122.4772748837)
57041 98796 3 18 950@Washington Clay St 5 1 1 10   03/16/2012 12:00:00 AM 3 3x3 Permit Number 768771 6010177.18626 2117200.01626 37.7940014192822 -122.40874722700701 (37.7940014192822, -122.408747227007)
72352 98801 3 44 950@Washington Clay St 3 1 1 10   03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010237.16405 2117207.30409 37.794024789059996 -122.408540211182 (37.79402478906, -122.408540211182)
74620 98800 3 44 950@Washington Clay St 2 1 1 10   03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010265.98354 2117209.83013 37.7940333389111 -122.408440670611 (37.7940333389111, -122.408440670611)
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)
79317 95366 3 5 3101X Van Ness Ave 1 1 1 10 6   14 3x3   6005504.90819 2120981.97244 37.8041229057048 -122.42518303152201 (37.8041229057048, -122.425183031522)
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)
81617 81843 3 12 1299X Larkin St 1 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
81659 113874 2 11 301x BRODERICK ST 11 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
82784 95034 3 43 3224 Pierce St 3 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
83093 98734 3 15 360 Grove St 10 1 1 10     14 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
83640 101808 3 11 3149 26th St 1 1 1 10   02/03/2015 12:00:00 AM 3 3x3   6008718.2 2100791.7 37.7488661984732 -122.41263499808599 (37.7488661984732, -122.412634998086)
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)
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)
88711 113813 2 2 4101x 25TH ST 6 1 1 10 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
88938 82383 3 12 1421 Pine St 4 1 1 10 6 09/11/2012 12:00:00 AM 3 3x3   6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
88973 113868 2 11 301x BRODERICK ST 5 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
89481 98733 3 15 360 Grove St 9 1 1 10     13 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
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)
94059 113817 2 49 4101x 25TH ST 10 1 1 10 6 02/16/2016 06:00:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
94908 95038 3 43 3224 Pierce St 9 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
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)
96370 113818 2 49 4101x 25TH ST 11 1 1 10 6 02/16/2016 05:57:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
97025 81841 3 12 1299X Larkin St 3 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
98563 113820 2 184 4101x 25TH ST 13 1 1 10 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
100401 81842 3 12 1299X Larkin St 2 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
101061 113808 2 18 4101x 25TH ST 1 1 1 10 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
101265 110403 2 256 419X 18TH AVE 4 1 1 10 10   22 3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
101830 113867 2 11 301x BRODERICK ST 4 1 1 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
102667 98999 3 79 2190X North Point St 5 1 1 10   01/20/2015 12:00:00 AM 3 3x3 Permit Number 771149 6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
104170 110739 6 333 1299x PERSIA AVE 6 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
104986 95041 3 43 3224 Pierce St 12 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
105585 113819 2 18 4101x 25TH ST 12 1 1 10 6   7 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
105794 95046 3 43 3224 Pierce St 10 5 1 10     13 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)
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)
107050 98735 3 15 360 Grove St 11 1 1 10     12 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
107894 111381 2 3 301x OCEAN AVE 3 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
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)
111208 95042 3 43 3224 Pierce St 2 5 1 10     11 3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
111252 81840 3 12 1299X Larkin St 4 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
113650 98731 3 15 360 Grove St 7 1 1 10     13 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
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)
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)
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)
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)
121695 111379 2 3 301x OCEAN AVE 1 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
122616 113811 2 2 4101x 25TH ST 4 1 1 10 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
124026 113821 2 50 4101x 25TH ST 14 1 1 10 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
124753 113814 2 49 4101x 25TH ST 7 1 1 10 6 02/16/2016 06:05:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
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)
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)
132930 110400 2 60 419X 18th Ave 1 1 1 10 10   28 3x3   5990269.5497 2112500.03817 37.77996145844129 -122.477285287094 (37.7799614584413, -122.477285287094)
140997 113815 2 15 4101x 25TH ST 8 1 1 10 6   8 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
141271 113816 2 2 4101x 25TH ST 9 1 1 10 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
141753 81839 3 12 1299X Larkin St 5 1 1 10 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
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)
143896 113822 2 130 4101x 25TH ST 15 1 1 10 6   7 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
Powered by Datasette · Query took 4.602ms · Data source: data.sfgov.org