sf-trees

Data source: data.sfgov.org

Custom SQL query returning 13 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14780 104045 3 131 1601X Kansas St 7 5 1 2     4 3x6   6011820.27046 2100794.2900099996 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805)
49190 241285 2 131 1201 Vermont St 7 9 1 1     12 Width 6ft   6011473.17853 2101977.48291 37.752276335990004 -122.40319162999901 (37.75227633599, -122.403191629999)
51103 196994 2 131 2 Napoleon St 7 4 1 1     7 Width 4ft   6013884.28274 2100137.93009 37.7473596740254 -122.39472477462401 (37.7473596740254, -122.394724774624)
58092 196987 2 131 1601 Kansas St 7 9 1 1     7 Width 5ft   6011820.27046 2100794.2900099996 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805)
82747 84204 1 131 655 Sunnydale Ave 7 1 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.709661919286496 -122.408259684415 (37.7096619192865, -122.408259684415)
88201 22267 1 131 4655X 03rd St 7 1 1 1   02/16/1995 12:00:00 AM 6 3X3   6015123.968669999 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472)
112269 101633 1 131 1585X Jerrold Ave 7 1 1 1   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.38905762495199 (37.7385310737434, -122.389057624952)
143214 96582 3 131 401x Otsego Ave 7 1 1 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398)
165267 196969 2 131 500 18th St 7 1 1 1     4 Width 3ft   6015866.243419999 2105844.6030099997 37.763138987107 -122.388269449981 (37.763138987107, -122.388269449981)
165408 179277 2 131 716 Peru Ave 7 1 1 1     6 Width 2ft   6005276.23831 2092458.42558 37.725791120054396 -122.423944813618 (37.7257911200544, -122.423944813618)
181885 179279 2 131 223 Pioche St 7 1 1 1     6 Width 2ft   6006275.12702 2093408.7720700002 37.7284569075468 -122.420559152977 (37.7284569075468, -122.420559152977)
186450 196986 2 131 1601 Kansas St 7 9 1 1     7 Width 5ft   6011820.27046 2100794.2900099996 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805)
188936 241351 2 131 2601 Mariposa St 7 1 1 1     6 Width 6ft   6009671.132730001 2105926.35263 37.7630182387282 -122.409702117253 (37.7630182387282, -122.409702117253)
Powered by Datasette · Query took 3.908ms · Data source: data.sfgov.org