sf-trees

Data source: data.sfgov.org

Custom SQL query returning 8 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2638 37832 3 42 450X Moscow St 19 5 1 4 2 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048)
6270 98640 3 26 3500X Fillmore St 19 1 1 4 2   5 3x3   6002237.13778 2120351.54005 37.8022067598879 -122.43644622191002 (37.8022067598879, -122.43644622191)
16401 78328 3 282 50 Pomona St 19 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014090.70522 2094312.9836799998 37.7313770539035 -122.39360335692601 (37.7313770539035, -122.393603356926)
85197 99341 3 60 450 30th Ave 19 1 1 4 2   24 4x5   5986573.71046 2113038.86406 37.7812257915862 -122.49011031791001 (37.7812257915862, -122.49011031791)
93801 77212 3 28 499X Hearst Ave 19 1 1 4 2 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
94089 42360 3 28 380X Flood Ave 19 1 1 4 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
109061 77668 3 2 299X Cambridge St 19 1 1 4 2 10/26/1984 12:00:00 AM 5 3x3   6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
112132 99365 3 2 451X 29th Ave 19 1 1 4 2   10 3x3   5986845.14154 2112755.50502 37.7804636155038 -122.48915047430201 (37.7804636155038, -122.489150474302)
Powered by Datasette · Query took 11.262ms · Data source: data.sfgov.org