sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2231 122750 3 94 693 Vermont St 8 1 1 4 2   9     6011285.1392 2105241.4016400003 37.761227830607204 -122.40407158333299 (37.7612278306072, -122.404071583333)
30530 101433 2 94 2501X Buchanan St 8 1 1 1       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261)
55200 224518 2 94 439 Shotwell St 8 1 1 1     16 Width 3ft   6007850.1916 2105341.72368 37.7613107723984 -122.41595874569401 (37.7613107723984, -122.415958745694)
86369 48037 1 94 3350 Mission St 8 1 1 1   07/11/2002 12:00:00 AM     Permit Number 45759 6006080.4837518 2098740.43590211 37.7430854999808 -122.42161056574 (37.7430854999808, -122.42161056574)
107487 115032 3 94 1009 HARRISON ST 8 1 1 2       3x10   6011058.0 2110680.0 37.776148288994705 -122.405240157274 (37.7761482889947, -122.405240157274)
130967 226498 2 94 1850 Harrison St 8 1 1 1     14 Width 3ft   6008688.72129 2107547.38011 37.767414104217295 -122.41321458949601 (37.7674141042173, -122.413214589496)
142937 34145 1 94 30 Steuart St 8 1 1 1   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.794049371853106 -122.394334961669 (37.7940493718531, -122.394334961669)
160486 224508 2 94 2201 Folsom St 8 1 1 1     17 Width 4ft   6008177.844880001 2105327.1946400004 37.761289294789 -122.414824499172 (37.761289294789, -122.414824499172)
170500 226479 2 94 3160 19th St 8 1 1 1     21 Width 3ft   6008278.21403 2105065.6529900003 37.7605768005893 -122.414458856385 (37.7605768005893, -122.414458856385)
188375 224570 2 94 3235 18th St 8 1 1 1     15 Width 3ft   6007990.36824 2105589.83292 37.7619999031047 -122.415491498431 (37.7619999031047, -122.415491498431)
Powered by Datasette · Query took 5.038ms · Data source: data.sfgov.org