sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1706 192430 3 44 340 06th St 1 1 1 2 2   9 Width 3ft   6011111.5516 2111334.7393 37.7779490450386 -122.405101020214 (37.7779490450386, -122.405101020214)
18479 107887 3 44 941 Washington St 5 1 1 4 2 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
23284 76311 3 44 299X Cambridge St 1 1 1 4 2 10/26/1984 12:00:00 AM 4 0   6006754.260559999 2093151.90933 37.7277786091743 -122.418884550584 (37.7277786091743, -122.418884550584)
103298 107884 3 44 941 Washington St 2 1 1 4 2     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
109088 98806 3 44 950x CLAY ST 8 1 1 4 2     3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
109673 107885 3 44 941 Washington St 3 1 1 4 2     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
121513 107883 3 44 941 Washington St 1 1 1 4 2         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
122517 98803 3 44 950x Clay St 2 1 1 4 2 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
130071 116057 2 44 2100x 19th St 1 1 1 4 2   2 3x3   6011480.97635 2105135.37266 37.760947638753 -122.40338680266001 (37.760947638753, -122.40338680266)
136322 98804 3 44 950x Clay St 1 1 1 4 2 03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010297.358630001 2117215.00262 37.794049298296706 -122.408332474088 (37.7940492982967, -122.408332474088)
141932 107886 3 44 941 Washington St 4 1 1 4 2 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
142763 98802 3 44 950x CLAY ST 3 1 1 4 2 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
158398 116058 2 44 2100x 19th St 2 1 1 4 2   2 3x3   6011458.59484 2105134.56728 37.760944177262004 -122.403464154268 (37.760944177262, -122.403464154268)
166938 116059 2 44 2100x 19th St 3 1 1 4 2   2 3x3   6011431.5308 2105131.75607 37.760934946603605 -122.40355755965099 (37.7609349466036, -122.403557559651)
172003 98805 3 44 950x Clay St 7 1 1 4 2 03/16/2012 12:00:00 AM 1 3x3 Permit Number 768771 6010143.10639 2117195.10642 37.793986029186 -122.408864800763 (37.793986029186, -122.408864800763)
172027 116857 2 44 950x Clay St 10 1 1 4 2   2 3x3   6010080.350930001 2117187.65635 37.793962057763 -122.409081415981 (37.793962057763, -122.409081415981)
183247 98791 3 44 950 Clay St 6 1 1 4 2   1 3x6 Permit Number 768771 6010164.1906 2117196.54488 37.7939911598214 -122.408791948484 (37.7939911598214, -122.408791948484)
Powered by Datasette · Query took 10.82ms · Data source: data.sfgov.org