sf-trees

Data source: data.sfgov.org

Custom SQL query returning 24 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
463 234072 3 26 1400 San Bruno Ave 2 1 1 4 4   4 Width 3ft   6011140.67766 2101759.7310900004 37.7516598624171 -122.404326151746 (37.7516598624171, -122.404326151746)
1968 251132 1 26 354 05th St 2 1 1 1 4 02/11/2006 12:00:00 AM   3x3 Permit Number 779305 6011875.0 2111882.0 37.779494345884295 -122.402498458881 (37.7794943458843, -122.402498458881)
3436 100973 3 26 450X Chestnut St 5 1 1 4 4   0   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
28296 33101 3 26 450X Chestnut St 1 1 1 4 4 11/01/1997 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754366996 -122.410721035819 (37.804135754367, -122.410721035819)
40243 100970 3 26 450X Chestnut St 2 1 1 4 4   9   Permit Number 37341 6009657.9659 2120896.9693 37.804123246932896 -122.41080500812201 (37.8041232469329, -122.410805008122)
59125 100975 3 26 450X Chestnut St 7 1 1 4 4   11   Permit Number 37341 6009580.8633 2120886.4184 37.8040899533369 -122.411071082632 (37.8040899533369, -122.411071082632)
64540 100974 3 26 450X Chestnut St 6 1 1 4 4   15   Permit Number 37341 6009596.2838 2120888.8532 37.8040975034287 -122.41101789076099 (37.8040975034287, -122.411017890761)
81591 95239 2 26 1220 Noe St 6 1 1 4 4   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
83876 109990 2 26 501X Shotwell St 7 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
89691 109988 2 26 501X Shotwell St 5 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
92640 109986 2 26 501X Shotwell St 3 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
93134 98908 2 26 501X Shotwell St 2 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
95002 95237 2 26 1220 Noe St 4 1 1 4 4   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
95046 109987 2 26 501X Shotwell St 4 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
96184 102636 1 26 2176 Mission St 2 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
107934 95238 2 26 1220 Noe St 5 1 1 4 4     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
109180 102635 1 26 2176 Mission St 1 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
117440 95240 2 26 1220 Noe St 7 1 1 4 4   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
120777 95241 2 26 1220 Noe St 8 1 1 4 4   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
121169 109989 2 26 501X Shotwell St 6 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
121486 95235 2 26 1220 Noe St 1 1 1 4 4   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
124070 98909 2 26 501X Shotwell St 1 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
142420 95236 2 26 1220 Noe St 2 1 1 4 4   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
145311 100972 3 26 450X Chestnut St 4 1 1 4 4 03/24/2016 07:43:00 AM 3   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
Powered by Datasette · Query took 3.352ms · Data source: data.sfgov.org