sf-trees

Data source: data.sfgov.org

Custom SQL query returning 11 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
721 183636 4 108 1478 47th Ave 1 2 1 1     4 3x9   5981570.9282 2105017.3718 37.7589076903569 -122.506822015648 (37.7589076903569, -122.506822015648)
109588 113335 4 12 2X STANFORD ST 1 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
117679 117480 4 191 601 PACHECO ST 2 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
119781 113337 4 12 2X STANFORD ST 2 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
120763 117479 4 191 601 PACHECO ST 1 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
127734 113338 4 12 2X STANFORD ST 3 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
128007 122701 4 6 2895 San Bruno Ave 5 1 1 1   11/16/2016 12:00:00 AM 3 3x9   6011453.69513 2092165.7679400002 37.7253343641976 -122.40256910729201 (37.7253343641976, -122.402569107292)
128042 117483 4 191 601 PACHECO ST 5 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
140623 117481 4 191 601 PACHECO ST 3 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
143480 117482 4 191 601 PACHECO ST 4 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
145746 122700 4 6 2895 San Bruno Ave 1 1 1 1   11/16/2016 12:00:00 AM 3 3x9   6011453.69513 2092165.7679400002 37.7253343641976 -122.40256910729201 (37.7253343641976, -122.402569107292)
Powered by Datasette · Query took 5.567ms · Data source: data.sfgov.org