sf-trees

Data source: data.sfgov.org

Custom SQL query returning 53 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4312 221469 3 109 400x Guerrero St 2 11 1 2   04/29/2015 10:33:00 AM 1 3x3   6005528.17729 2106528.83552 37.7644394796106 -122.42407404799499 (37.7644394796106, -122.424074047995)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 4.122ms · Data source: data.sfgov.org