sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
34860 237993 2 35 480 Jersey St 3 10 1 1     4 Width 4ft   6001987.72906 2101502.95079 37.7504390831161 -122.43595981461701 (37.7504390831161, -122.435959814617)
41433 139465 2 35 855 CENTRAL AVE 2 10 1 1     7 Width 0ft   5999527.6632 2111481.3292 37.77769715931579 -122.445184184965 (37.7776971593158, -122.445184184965)
47858 142823 2 35 1742 POLK ST 2 10 1 1     1 Width 0ft   6006601.0091 2116911.6099 37.79300857718 -122.421100695716 (37.79300857718, -122.421100695716)
49057 142822 2 35 1742 POLK ST 1 10 1 1     1 Width 0ft   6006604.1049 2116897.4579 37.7929698938345 -122.421088978741 (37.7929698938345, -122.421088978741)
50185 238001 2 35 591 27th St 7 10 1 1     9     6002762.01889 2100032.1411900003 37.746444541887705 -122.43317718719601 (37.7464445418877, -122.433177187196)
63044 196410 2 35 1143 Howard St 2 10 1 1     1 Width 3ft   6009614.35227 2111076.8827400003 37.7771572198736 -122.410262172786 (37.7771572198736, -122.410262172786)
171106 196409 2 35 1143 Howard St 1 10 1 1     9 Width 3ft   6009598.37036 2111065.11658 37.7771240168943 -122.41031662852801 (37.7771240168943, -122.410316628528)
104672 64402 1 35 777 Stockton St 1 10 1 1 1 05/14/1988 12:00:00 AM     Permit Number 25247 6010475.1 2116722.1 37.792705858273294 -122.407682697096 (37.7927058582733, -122.407682697096)
127063 101446 1 35 777 Stockton St 5 10 1 1         Permit Number 25247 6010475.1 2116722.1 37.792705858273294 -122.407682697096 (37.7927058582733, -122.407682697096)
143083 101447 1 35 777 Stockton St 6 10 1 1         Permit Number 25247 6010475.1 2116722.1 37.792705858273294 -122.407682697096 (37.7927058582733, -122.407682697096)
Powered by Datasette · Query took 16.116ms · Data source: data.sfgov.org