sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
38449 226599 2 27 1832 Castro St 1 9 1 1     9 Width 3ft   6002599.9125 2100157.5460099997 37.746779676940896 -122.43374669365 (37.7467796769409, -122.43374669365)
44643 177014 2 27 81 Lamartine St 4 1 1 1     9 Width 2ft   6002672.79218 2094323.6061200001 37.7307651596849 -122.433077929925 (37.7307651596849, -122.433077929925)
47869 129491 2 27 2536 Baker St 2 2 1 1     9 Width 4ft   5999689.18555 2117591.31365 37.794482803901296 -122.445064787505 (37.7944828039013, -122.445064787505)
56500 177008 2 27 67 Capistrano Ave 1 9 1 1     9     6001385.71309 2093783.96595 37.7292103388668 -122.43748892737301 (37.7292103388668, -122.437488927373)
63341 207360 2 27 374 Judson Ave 1 1 1 1     9 Width 2ft   5997612.78816 2093589.9194 37.7284623061695 -122.450518204475 (37.7284623061695, -122.450518204475)
65074 67318 1 27 666 08th Ave 1 1 1 1 1 07/15/1992 12:00:00 AM 9   Permit Number 30800 5993501.91813 2110961.7349 37.7759247065994 -122.46599136010799 (37.7759247065994, -122.465991360108)
66041 129492 2 27 2536 Baker St 3 2 1 1     9 Width 4ft   5999690.83284 2117600.09007 37.794506995647 -122.445059718941 (37.794506995647, -122.445059718941)
67219 129495 2 27 1136 Havens St 1 9 1 1     9 Width 7ft   6007480.35855 2119354.0245 37.7997643702969 -122.418231335218 (37.7997643702969, -122.418231335218)
69070 207341 2 27 538 Joost Ave 3 9 1 1     9     5998515.2216 2095011.0330299998 37.7324159597185 -122.447500710116 (37.7324159597185, -122.447500710116)
74277 67405 1 27 774 20th Ave 1 1 1 1 1 07/30/1992 12:00:00 AM 9   Permit Number 30904 5989782.793 2110097.20217 37.7733356814764 -122.478793391379 (37.7733356814764, -122.478793391379)
76282 226604 2 27 495 Collingwood St 5 9 1 1     9 Width 2ft   6002163.6712 2103050.21539 37.7546974962127 -122.435462066843 (37.7546974962127, -122.435462066843)
77335 207193 2 27 312 Hearst Ave 4 1 1 1     9 Width 2ft   5999342.629819999 2094390.1530400002 37.7307584183688 -122.444595567153 (37.7307584183688, -122.444595567153)
162483 207356 2 27 247 Staples Ave 3 9 1 1     9     5998447.51248 2093764.7485200001 37.7289900868122 -122.447645112433 (37.7289900868122, -122.447645112433)
168679 226579 2 27 110 Carmel St 1 10 1 1     9 Width 3ft   5998203.55994 2105386.43051 37.7608864542601 -122.44932545342199 (37.7608864542601, -122.449325453422)
171574 177017 2 27 345 Mount Vernon Ave 1 9 1 1     9 Width 2ft   5998458.65026 2089723.00143 37.7178930256111 -122.447315825681 (37.7178930256111, -122.447315825681)
182658 129487 2 27 3310 Baker St 1 9 1 1     9 Width 6ft   5999338.381580001 2120194.27566 37.8016098133151 -122.446465960942 (37.8016098133151, -122.446465960942)
Powered by Datasette · Query took 5.548ms · Data source: data.sfgov.org