sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
85172 43003 1 35 205X Rose St 8 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42873 6005609.30796774 2109736.9244771 37.7732527046739 -122.424021592666 (37.7732527046739, -122.424021592666)
85562 42761 1 35 415 Buchanan St 8 1 1 1   06/26/2000 12:00:00 AM     Permit Number 42742 6004604.76721884 2109944.08482631 37.7737647507648 -122.42751119704201 (37.7737647507648, -122.427511197042)
87728 37253 1 35 4200 20th St 8 1 1 1 1 06/12/1998 12:00:00 AM     Permit Number 39805 6002396.16255256 2104159.25249428 37.7577558475859 -122.434737351341 (37.7577558475859, -122.434737351341)
98435 36038 1 35 1660X BRYANT ST 8 1 1 1   04/27/1998 12:00:00 AM 2   Permit Number 39178 6009346.0 2106886.0 37.7656349852358 -122.410894426294 (37.7656349852358, -122.410894426294)
104105 42375 1 35 601 Foerster St 8 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42549 5998097.42751354 2095265.42548706 37.733090576245104 -122.448963434318 (37.7330905762451, -122.448963434318)
109151 88233 1 35 2108 Hayes St 8 1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51222 5997802.0 2109918.0 37.7733060118428 -122.451041052194 (37.7733060118428, -122.451041052194)
109513 50543 1 35 60 29th St 8 1 1 1   11/06/2003 12:00:00 AM     Permit Number 47175 6006180.0 2099188.0 37.74432002092679 -122.421298240567 (37.7443200209268, -122.421298240567)
168201 38758 1 35 133 Shipley St 8 1 1 1   10/20/1998 12:00:00 AM 3   Permit Number 40630 6012273.2979999995 2112461.93462 37.7811089398776 -122.401161330453 (37.7811089398776, -122.401161330453)
35667 138101 2 35 1750 Webster St 8 1 1 1     4 Width 0ft   6003541.5257 2114778.8993 37.7869797508763 -122.43153434535401 (37.7869797508763, -122.431534345354)
67840 183942 2 35 1805 Quintara St 8 1 1 1     1 Width 0ft   5987837.1544 2100978.5872 37.748185287488496 -122.484854460213 (37.7481852874885, -122.484854460213)
72821 178885 2 35 451 Athens St 8 1 1 1     4 Width 3ft   6003721.71366 2090575.2726099999 37.720532513349106 -122.42918447430401 (37.7205325133491, -122.429184474304)
111214 117171 2 35 299x ALMA ST 8 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
126246 110550 2 35 2x LILY ST 8 1 1 1       2.5x4   6006369.0 2110405.0 37.775129941044604 -122.421441165405 (37.7751299410446, -122.421441165405)
151489 238026 2 35 251 Alma St 8 1 1 1     4 Width 3ft   5997640.69708 2106136.91348 37.7629148787356 -122.45132626601801 (37.7629148787356, -122.451326266018)
168823 137953 2 35 1615 SUTTER ST 8 1 1 1     1 Width 0ft   6004788.4681 2114683.7679 37.786789139709 -122.427213425712 (37.786789139709, -122.427213425712)
5350 28646 3 35 1600X Webster St 8 11 1 2     8 6   6003557.7645 2114374.9896 37.7858716371659 -122.431449317827 (37.7858716371659, -122.431449317827)
5618 87403 3 35 1300 Webster St 8 11 1 2   04/21/2008 12:00:00 AM 10 3x3   6003687.1999 2113392.3659 37.7831809343135 -122.430931353807 (37.7831809343135, -122.430931353807)
146849 106987 3 35 1737-1795 Post St 8 1 1 2   04/01/2012 12:00:00 AM 2     6003830.0102 2114195.5789 37.78539444652429 -122.430494617565 (37.7853944465243, -122.430494617565)
Powered by Datasette · Query took 10.977ms · Data source: data.sfgov.org