sf-trees

Data source: data.sfgov.org

Custom SQL query returning 8 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9895 24292 3 98 403 Winfield St 1 1 1 2   10/28/1992 12:00:00 AM 3 3X3            
92800 12755 3 98 1733 Lake St 1 1 1 2   02/24/2008 12:00:00 AM 3 3X3   5990033.85435 2114674.56985 37.785918437001705 -122.478259694764 (37.7859184370017, -122.478259694764)
128536 19363 3 98 738 Shields St 1 1 1 2     3 3X3   5992103.0127542 2089880.5617979001 37.7179604248963 -122.469295726054 (37.7179604248963, -122.469295726054)
93443 15888 3 98 5625 Mission St 1 1 1 2     3 3X3   5998561.46984 2087228.1352400002 37.711048567191604 -122.446781008521 (37.7110485671916, -122.446781008521)
94867 15877 3 98 5508 Mission St 1 1 1 2   12/15/1997 12:00:00 AM 3 3X3   5999048.25069 2087729.15393 37.7124520473945 -122.445134579389 (37.7124520473945, -122.445134579389)
91858 9382 3 98 337 Gold Mine Dr 1 1 1 2     0 3X3   6001129.4629101 2097791.8544146 37.74020049817771 -122.43866187060699 (37.7402004981777, -122.438661870607)
118241 4313 3 98 727 Chenery St 1 1 2 2   08/17/2013 12:00:00 AM   3X3   6002321.2517800005 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497)
127970 4893 3 98 745X Mansell St 1 1 1 2     12 3X3   6009751.8988059005 2090059.5024836997 37.7194558413593 -122.408303589874 (37.7194558413593, -122.408303589874)
Powered by Datasette · Query took 3.06ms · Data source: data.sfgov.org