sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3111 118355 3 109 100X Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 3              
182868 221512 3 109 1300x Guerrero St 10 11 1 2     7 Width 3ft   6005835.43443 2101000.02463 37.749275995297296 -122.422618416129 (37.7492759952973, -122.422618416129)
159464 221532 3 109 1100x Guerrero St 10 11 1 2     8 Width 3ft   6005770.103999999 2102168.30473 37.7524801376575 -122.42292735211201 (37.7524801376575, -122.422927352112)
176544 221552 3 109 1000x Guerrero St 10 11 1 2     3 Width 3ft   6005734.10722 2102815.94179 37.754256367947704 -122.423097864468 (37.7542563679477, -122.423097864468)
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)
174460 221422 3 109 800x Guerrero St 10 11 1 2     6 Width 3ft   6005661.88318 2104154.96713 37.7579289437835 -122.42344282103001 (37.7579289437835, -122.42344282103)
5113 152421 3 109 700x Guerrero St 10 11 1 2     0 Width 3ft   6005642.99765 2104457.73967 37.7587592203909 -122.42352966049 (37.7587592203909, -122.42352966049)
4517 221503 3 109 600x Guerrero St 10 11 1 2   02/21/2015 11:06:00 PM 2 Width 3ft   6005610.53101 2105047.42068 37.7603765134773 -122.423683871708 (37.7603765134773, -122.423683871708)
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)
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)
4419 221477 3 109 400x Guerrero St 10 11 1 2   04/29/2015 05:29:00 AM 1 Width 3ft   6005543.73868 2106251.90953 37.763679985054495 -122.424000531101 (37.7636799850545, -122.424000531101)
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)
4384 221465 3 109 300x Guerrero St 10 11 1 2   06/19/2015 10:21:00 AM 2 Width 3ft   6005511.348730001 2106807.4282299997 37.76520347889029 -122.42415206777599 (37.7652034788903, -122.424152067776)
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)
4359 221446 3 109 200x Guerrero St 10 11 1 2   02/09/2016 11:45:00 AM 1 Width 3ft   6005477.30623 2107402.8649 37.7668364840384 -122.424312165974 (37.7668364840384, -122.424312165974)
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)
773 221437 3 109 100x Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 1 Width 3ft   6005441.98545 2108105.3361400003 37.7687633076137 -122.424484307027 (37.7687633076137, -122.424484307027)
Powered by Datasette · Query took 2.549ms · Data source: data.sfgov.org