sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
26035 190622 2 67 111 Vermont St 4 1 1 1     4 Width 3ft   6011129.36426 2108026.35569 37.7688659805044 -122.40480642029101 (37.7688659805044, -122.404806420291)
30001 228357 2 67 650 Florida St 4 1 1 1     3 Width 3ft   6009240.17832 2105294.68845 37.7612596738224 -122.411148025686 (37.7612596738224, -122.411148025686)
102740 47727 1 67 85 Sycamore St 4 1 1 1   05/23/2002 12:00:00 AM     Permit Number 45520 6006351.18478147 2105818.87737664 37.7625365339004 -122.421177070604 (37.7625365339004, -122.421177070604)
109787 36542 1 67 190 Gates St 4 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39415 6008260.22671845 2097736.01770388 37.7404502589313 -122.414002536769 (37.7404502589313, -122.414002536769)
117587 113245 2 67 1301X 04TH ST 4 1 1 1       5x5   5994883.0 2106671.0 37.7642230519674 -122.46090282761001 (37.7642230519674, -122.46090282761)
138883 79132 1 67 1001 Le Conte Ave 4 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52373 6013117.42744406 2089558.25653077 37.718267407089 -122.39663499597201 (37.718267407089, -122.396634995972)
143298 98479 1 67 531X Franconia St 4 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
149100 228364 2 67 685 Florida St 4 1 1 1     3 Width 3ft   6009253.05651 2105058.10552 37.7606107931857 -122.41108677375799 (37.7606107931857, -122.411086773758)
185405 201614 2 67 98 Jerrold Ave 4 17 1 1     3 Width 4ft   6020747.34365 2092993.8196 37.728122515333396 -122.370498661104 (37.7281225153334, -122.370498661104)
Powered by Datasette · Query took 3.026ms · Data source: data.sfgov.org