sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
30852 240192 2 82 15 Whitney St 1 1 1 1     15 Width 3ft   6004287.41019 2098213.31975 37.7415368893219 -122.42777298295401 (37.7415368893219, -122.427772982954)
35804 239300 2 82 927 York St 1 1 1 1     15 Width 3ft   6009964.45155 2103786.9298 37.757160299531996 -122.408536698407 (37.757160299532, -122.408536698407)
53135 197099 2 82 361 Pennsylvania Ave 1 1 1 1     15 Width 3ft   6014371.32039 2105439.78975 37.7619445120636 -122.39341159536801 (37.7619445120636, -122.393411595368)
69560 239354 2 82 187 Day St 1 1 1 1     15 Width 2ft   6004748.91753 2098687.71701 37.742865571999104 -122.42621101343201 (37.7428655719991, -122.426211013432)
69666 240194 2 82 48 Whitney St 1 1 1 1     15 Width 3ft   6004261.63308 2097975.00788 37.7408810812017 -122.42784513465901 (37.7408810812017, -122.427845134659)
70530 73459 2 82 330 Utah St 1 1 1 1 1 09/17/1994 12:00:00 AM 15     6010582.5171300005 2106716.25151 37.765238152235206 -122.40660560128299 (37.7652381522352, -122.406605601283)
130140 239310 2 82 460 Fair Oaks St 1 1 1 1     15 Width 3ft   6005491.5697099995 2101034.9456700003 37.7493524745442 -122.42380999086001 (37.7493524745442, -122.42380999086)
163677 239332 2 82 3284 Harrison St 1 1 1 1     15 Width 3ft   6009010.21186 2099567.25485 37.7455205280624 -122.411538719955 (37.7455205280624, -122.411538719955)
165260 54444 1 82 626 Mississippi St 1 1 1 1   06/23/1972 12:00:00 AM 15   Permit Number 10222 6014089.82372 2104201.41345 37.7585285559536 -122.394298481614 (37.7585285559536, -122.394298481614)
166384 239241 2 82 1301 Potrero Ave 1 4 1 1     15 Width 3ft   6010653.63145 2101615.38344 37.7512362871225 -122.406000261299 (37.7512362871225, -122.406000261299)
186231 239333 2 82 3258 Harrison St 1 1 1 1     15 Width 3ft   6009001.08587 2099726.03471 37.7459559905813 -122.411581492612 (37.7459559905813, -122.411581492612)
148823 99598 1 82 3001 Webster St 2 1 1 1     15   Permit Number 17057 6002874.08515 2118929.42484 37.7983381750246 -122.434140356598 (37.7983381750246, -122.434140356598)
151351 213953 2 82 360 Faxon Ave 2 1 1 1     15 Width 3ft   5994770.431919999 2090973.1015700002 37.7211140599462 -122.460154799032 (37.7211140599462, -122.460154799032)
177889 239322 2 82 1682 Alabama St 2 1 1 1     15 Width 3ft   6009287.32125 2099523.77754 37.7454166887246 -122.410577445415 (37.7454166887246, -122.410577445415)
177196 213954 2 82 360 Faxon Ave 3 1 1 1     15 Width 3ft   5994772.0848 2091005.96515 37.721204390545104 -122.460151465241 (37.7212043905451, -122.460151465241)
188403 239243 2 82 1301 Potrero Ave 4 4 1 1     15 Width 3ft   6010651.8200900005 2101663.18223 37.751367430767395 -122.40600989216101 (37.7513674307674, -122.406009892161)
159725 213957 2 82 360 Faxon Ave 6 1 1 1     15 Width 3ft   5994771.7805 2091087.8520099998 37.7214292147603 -122.460158446674 (37.7214292147603, -122.460158446674)
Powered by Datasette · Query took 16.417ms · Data source: data.sfgov.org