sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
24177 237873 2 72 1200 San Jose Ave 5 9 1 1     11 Width 4ft   6004198.3369 2096122.91618 37.7357920776323 -122.427932046027 (37.7357920776323, -122.427932046027)
32082 214339 2 72 10 Granada Ave 5 1 1 1     3 Width 3ft   5995645.61653 2089973.7563200002 37.7184203952771 -122.45705730996401 (37.7184203952771, -122.457057309964)
46954 237909 2 72 3911 21st St 5 17 1 1     17     6002350.80679 2103530.36749 37.7560265053261 -122.43484923730499 (37.7560265053261, -122.434849237305)
60249 196325 2 72 582 Rhode Island St 5 9 1 1     4     6011758.16915 2105659.78061 37.7624030241958 -122.402464984075 (37.7624030241958, -122.402464984075)
60540 135872 2 72 2550 Pierce St 5 1 1 1     5 Width 4ft   6001695.18556 2117280.97246 37.7937449767048 -122.43810155185601 (37.7937449767048, -122.438101551856)
66579 237936 2 72 272 Corbett Ave 5 17 1 1     4 Width 3ft   5999637.58135 2105322.06296 37.7607916396321 -122.444361196632 (37.7607916396321, -122.444361196632)
71198 214353 2 72 50 Garcia Ave 5 2 1 1     4 Width 3ft   5995149.72336 2099349.67966 37.74413591023829 -122.45945004977399 (37.7441359102383, -122.459450049774)
165180 214347 2 72 649 Parnassus Ave 5 1 1 1     4 Width 3ft   5995088.00725 2106121.15655 37.762725118180704 -122.460153932955 (37.7627251181807, -122.460153932955)
166052 135874 2 72 941 Vallejo St 5 7 1 1     14     6008901.53322 2118681.17119 37.7979967743805 -122.413265921012 (37.7979967743805, -122.413265921012)
186984 113952 2 72 1416 Powell St 5 1 1 1     11 3x3   6009764.02998 2118627.67395 37.7978982689348 -122.410277642896 (37.7978982689348, -122.410277642896)
Powered by Datasette · Query took 3.76ms · Data source: data.sfgov.org