sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1982 118349 3 109 100X Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 3              
2168 118346 3 109 100X Guerrero St 1 11 1 2   07/15/2016 05:47:00 AM 3              
2766 118353 3 109 100X Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 3              
3111 118355 3 109 100X Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 3              
3394 118348 3 109 100X Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 3              
4215 118354 3 109 100X Guerrero St 9 11 1 2   07/15/2016 06:05:00 AM 3              
4374 118351 3 109 100X Guerrero St 6 11 1 2   07/15/2016 06:32:00 AM 3              
5429 118350 3 109 100X Guerrero St 5 11 1 2   07/15/2016 05:53:00 AM 3              
5643 118347 3 109 100X Guerrero St 2 11 1 2   07/15/2016 05:39:00 AM 3              
5661 118352 3 109 100X Guerrero St 7 11 1 2   07/15/2016 06:56:00 AM 3              
80086 37574 1 109 30 Collingwood St 1 1 1 1 1 08/15/2014 12:00:00 AM 3   Permit Number 773155 6001973.00287599 2105680.02476784 37.7619074866084 -122.43630964556101 (37.7619074866084, -122.436309645561)
35135 56924 1 109 140 Tingley St 1 1 1 1   08/15/1974 12:00:00 AM 3   Permit Number 14167 6002240.5096 2093994.70553 37.7298375431559 -122.434548888919 (37.7298375431559, -122.434548888919)
144269 56594 1 109 533 Laidley St 1 1 1 1   11/16/2012 12:00:00 AM 3 3x3 Permit Number 768959 6003224.0 2096098.0 37.7356684939052 -122.431298930259 (37.7356684939052, -122.431298930259)
145556 66265 1 109 4020 26th St 1 1 1 1   10/30/1990 12:00:00 AM 3 6x9 Permit Number 29370 6003740.3803829 2100725.5739603 37.7484039979455 -122.429843577344 (37.7484039979455, -122.429843577344)
63120 105071 6 109 1808 Vallejo St 1 7 1 1     3   Permit Number 771033 6004794.05676 2118138.55822 37.796275437823894 -122.427440299436 (37.7962754378239, -122.427440299436)
75755 115513 3 109 200x Guerrero St 4 11 1 2   02/09/2016 11:41:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
80319 115517 3 109 200x Guerrero St 8 11 1 2   02/09/2016 12:52:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
86793 115518 3 109 200x Guerrero St 9 11 1 2   02/09/2016 12:33:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
97329 115520 3 109 200x Guerrero St 11 11 1 2   02/09/2016 10:50:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
105439 115510 3 109 200x Guerrero St 1 11 1 2   02/09/2016 12:55:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
105592 115519 3 109 200x Guerrero St 10 11 1 2   02/09/2016 11:45:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
106984 115515 3 109 200x Guerrero St 6 11 1 2   02/09/2016 11:34:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
118209 115511 3 109 200x Guerrero St 2 11 1 2   02/09/2016 12:48:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
146089 115514 3 109 200x Guerrero St 5 11 1 2   02/09/2016 11:36:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
88573 109696 3 109 600x GUERRERO ST 4 11 1 2   02/21/2015 10:57:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
91073 109698 3 109 600x GUERRERO ST 6 11 1 2   02/28/2015 11:01:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
92681 109700 3 109 600x GUERRERO ST 8 11 1 2   02/21/2015 11:08:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
95444 109697 3 109 600x GUERRERO ST 5 11 1 2   02/21/2015 10:59:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
106423 109703 3 109 600x GUERRERO ST 11 11 1 2   02/21/2015 11:05:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
107320 109701 3 109 600x GUERRERO ST 9 11 1 2   02/21/2015 11:07:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
110419 109704 3 109 600x GUERRERO ST 12 11 1 2   02/28/2015 10:40:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
118317 109694 3 109 600x GUERRERO ST 2 11 1 2   02/21/2015 10:54:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
123889 109693 3 109 600x GUERRERO ST 1 11 1 2   02/21/2015 10:53:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
126273 109695 3 109 600x GUERRERO ST 3 11 1 2   02/21/2015 12:00:00 AM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
142527 109699 3 109 600x GUERRERO ST 7 11 1 2   02/28/2015 11:10:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
144040 109702 3 109 600x GUERRERO ST 10 11 1 2   02/21/2015 11:06:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
81008 110625 3 109 400X GUERRERO ST 8 11 1 2   04/29/2015 10:13:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
81226 110627 3 109 400X GUERRERO ST 10 11 1 2   04/29/2015 05:29:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
81262 110626 3 109 400X GUERRERO ST 9 11 1 2   04/29/2015 09:37:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
85719 110619 3 109 400X GUERRERO ST 2 11 1 2   04/29/2015 10:33:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
86005 110628 3 109 400X GUERRERO ST 11 11 1 2   04/29/2015 05:18:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
90408 110621 3 109 400X GUERRERO ST 4 11 1 2   04/29/2015 10:27:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
91609 110624 3 109 400X GUERRERO ST 7 11 1 2   04/29/2015 10:16:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
95136 110618 3 109 400X GUERRERO ST 1 11 1 2   04/29/2015 10:37:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
100063 110650 3 109 400X GUERRERO ST 13 11 1 2   04/29/2015 05:03:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
104357 110622 3 109 400X GUERRERO ST 5 11 1 2   04/29/2015 10:24:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
120306 110649 3 109 400X GUERRERO ST 12 11 1 2   04/28/2015 07:46:00 PM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
128230 110620 3 109 400X GUERRERO ST 3 11 1 2   04/29/2015 10:30:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
129058 110623 3 109 400X GUERRERO ST 6 11 1 2   04/29/2015 10:20:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
82356 110764 3 109 300X GUERRERO ST 6 11 1 2   06/19/2015 10:37:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
93719 110771 3 109 300X GUERRERO ST 13 11 1 2   06/19/2015 10:10:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
94270 110769 3 109 300X GUERRERO ST 11 11 1 2   06/19/2015 10:17:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
94846 110770 3 109 300X GUERRERO ST 12 11 1 2   06/19/2015 10:14:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
97820 110763 3 109 300X GUERRERO ST 5 11 1 2   06/19/2015 10:41:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
99866 110766 3 109 300X GUERRERO ST 8 11 1 2   06/19/2015 10:29:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
101837 110765 3 109 300X GUERRERO ST 7 11 1 2   06/19/2015 10:33:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
113542 110761 3 109 300X GUERRERO ST 3 11 1 2   06/19/2015 10:49:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
116936 110767 3 109 300X GUERRERO ST 9 11 1 2   06/19/2015 10:25:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
121602 110760 3 109 300X GUERRERO ST 2 11 1 2   06/19/2015 10:54:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
122606 110762 3 109 300X GUERRERO ST 4 11 1 2   06/19/2015 10:45:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
126939 110768 3 109 300X GUERRERO ST 10 11 1 2   06/19/2015 10:21:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
140294 110759 3 109 300X GUERRERO ST 1 11 1 2   06/19/2015 10:59:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
4381 221459 3 109 300x Guerrero St 4 11 1 2   06/19/2015 10:45:00 AM 3 Width 3ft   6005495.536040001 2107056.71588 37.7658870706576 -122.424224491084 (37.7658870706576, -122.424224491084)
1879 221463 3 109 300x Guerrero St 8 11 1 2   06/08/2017 12:00:00 AM 3 Width 3ft   6005505.30672 2106900.54865 37.7654588242817 -122.42417958883301 (37.7654588242817, -122.424179588833)
151865 221485 3 109 500x Guerrero St 5 11 1 2     3 Width 3ft   6005566.92978 2105826.00789 37.762511869155105 -122.42389003321101 (37.7625118691551, -122.423890033211)
55100 221486 3 109 500x Guerrero St 6 11 1 2     3 Width 3ft   6005569.00136 2105791.30468 37.7624166992856 -122.423880400579 (37.7624166992856, -122.423880400579)
66900 221490 3 109 500x Guerrero St 10 11 1 2     3 Width 3ft   6005576.38505 2105666.63585 37.7620748049423 -122.423845997918 (37.7620748049423, -122.423845997918)
184414 221498 3 109 600x Guerrero St 5 11 1 2     3 Width 3ft   6005599.77613 2105242.7413 37.7609122108583 -122.423734955914 (37.7609122108583, -122.423734955914)
141675 91237 3 109 808 Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3 4x15   6005611.0 2104262.0 37.7582199589604 -122.423626406477 (37.7582199589604, -122.423626406477)
117919 91293 3 109 812x Guerrero St 2 11 1 2   11/20/2001 12:00:00 AM 3     6005612.0 2104238.0 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698)
123181 91238 3 109 812x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005612.0 2104238.0 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698)
87711 91236 3 109 804 Guerrero St 1 22 1 2   11/20/2009 12:00:00 AM 3 3x100   6005614.0 2104300.0 37.758324467407704 -122.423618732861 (37.7583244674077, -122.423618732861)
79149 91241 3 109 842x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
82614 91242 3 109 842x Guerrero St 3 11 1 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
94067 91239 3 109 842x Guerrero St 1 28 1 2   11/20/1989 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
145184 91240 3 109 842x Guerrero St 2 11 1 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
49955 91244 3 109 852x Guerrero St 1 11 1 2   01/20/2016 07:21:00 AM 3     6005625.0 2104006.0 37.757517833055395 -122.423559787953 (37.7575178330554, -122.423559787953)
109310 91243 3 109 850x Guerrero St 1 11 1 2   02/10/2009 12:00:00 AM 3     6005625.0 2104018.0 37.7575507822519 -122.423560641088 (37.7575507822519, -122.423560641088)
79479 91245 3 109 870x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005631.0 2103898.0 37.7572216289442 -122.423531359417 (37.7572216289442, -122.423531359417)
88269 91249 3 109 870x Guerrero St 1 11 1 2   01/20/2016 07:26:00 AM 3     6005631.0 2103898.0 37.7572216289442 -122.423531359417 (37.7572216289442, -122.423531359417)
101453 91246 3 109 876x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005633.0 2103862.0 37.7571228942355 -122.423521883288 (37.7571228942355, -122.423521883288)
90343 91247 3 109 880x Guerrero St 1 11 1 2   01/20/2016 07:29:00 AM 3     6005634.0 2103838.0 37.7570570522806 -122.423516718678 (37.7570570522806, -122.423516718678)
18919 110775 3 109 1000X GUERRERO ST 4 11 1 2   05/26/2015 02:57:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
80233 110778 3 109 1000X GUERRERO ST 7 11 1 2   05/26/2015 02:43:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
80584 110774 3 109 1000X GUERRERO ST 3 11 1 2   05/26/2015 03:02:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
82047 110777 3 109 1000X GUERRERO ST 6 11 1 2   05/26/2015 02:47:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
93547 110779 3 109 1000X GUERRERO ST 8 11 1 2   05/26/2015 02:35:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
97980 110776 3 109 1000X GUERRERO ST 5 11 1 2   05/26/2015 02:53:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
102576 110781 3 109 1000X GUERRERO ST 10 11 1 2   05/26/2015 02:26:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
114885 110772 3 109 1000X GUERRERO ST 1 11 1 2   05/26/2015 03:10:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
121580 110782 3 109 1000X GUERRERO ST 11 11 1 2   05/26/2015 02:21:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
124792 110780 3 109 1000X GUERRERO ST 9 11 1 2   05/26/2015 02:30:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
139744 110783 3 109 1000X GUERRERO ST 12 11 1 2   05/26/2015 02:16:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
141015 110784 3 109 1000X GUERRERO ST 13 11 1 2   05/26/2015 02:11:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
144929 110773 3 109 1000X GUERRERO ST 2 11 1 2   05/26/2015 03:06:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
83208 91248 3 109 888x Guerrero St 1 11 1 2   01/20/2016 07:34:00 AM 3     6005668.887935 2103795.421709 37.7569421113624 -122.423393035961 (37.7569421113624, -122.423393035961)
141128 91251 3 109 906X Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005675.14042 2103682.124768 37.756631377266295 -122.42336335858299 (37.7566313772663, -122.423363358583)
111602 91252 3 109 908x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005675.762116 2103670.859284 37.7566004799608 -122.42336040770901 (37.7566004799608, -122.423360407709)
128795 91254 3 109 928x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005681.9790819995 2103558.204453 37.7562915069181 -122.423330899086 (37.7562915069181, -122.423330899086)
108090 91255 3 109 940x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005685.709261 2103490.611554 37.75610612308 -122.423313194032 (37.75610612308, -122.423313194032)
118503 91256 3 109 940X Guerrero St 2 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005685.709261 2103490.611554 37.75610612308 -122.423313194032 (37.75610612308, -122.423313194032)
Powered by Datasette · Query took 3.259ms · Data source: data.sfgov.org