sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
253 251256 2 67 4091x Alemany Blvd 1 1 1 1       3x3   5991686.0 2086783.0 37.70943116445179 -122.470511668938 (37.7094311644518, -122.470511668938)
10151 173889 6 67 190 Holladay Ave 1 1 1 1       3x3   6010824.0 2099939.0 37.746642831954496 -122.405293064953 (37.7466428319545, -122.405293064953)
30779 60998 1 67 340 Brannan St 1 1 1 1   09/20/1991 12:00:00 AM 6 3x3 Permit Number 30085 6014626.949469999 2112460.0438599996 37.7812347712083 -122.393018675278 (37.7812347712083, -122.393018675278)
43415 82842 1 67 624 Natoma St 1 1 1 1   07/07/2009 12:00:00 AM 5 3x3 Permit Number 52445 6009524.75632 2111364.58269 37.7779421535385 -122.4105924362 (37.7779421535385, -122.4105924362)
78665 116223 2 67 195 COLLINGWOOD ST 1 1 1 1     3 3x3   6002090.0 2104773.0 37.7594236635512 -122.435840099174 (37.7594236635512, -122.435840099174)
83784 47253 1 67 1001 Le Conte Ave 2 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52373 6013117.42744406 2089558.25653077 37.718267407089 -122.39663499597201 (37.718267407089, -122.396634995972)
105830 79561 1 67 1001 Le Conte Ave 3 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52373 6013117.42744406 2089558.25653077 37.718267407089 -122.39663499597201 (37.718267407089, -122.396634995972)
120424 72837 8 67 2624 21st St 1 1 1 1   05/06/2015 12:00:00 AM 3 3x3 Permit Number 770762 6010331.33933918 2104014.11752446 37.7578046465334 -122.407283867997 (37.7578046465334, -122.407283867997)
133807 111385 1 67 340 Brannan St 3 1 1 1     5 3x3   6014582.17665 2112417.55167 37.7811156101297 -122.39317059416099 (37.7811156101297, -122.393170594161)
138883 79132 1 67 1001 Le Conte Ave 4 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52373 6013117.42744406 2089558.25653077 37.718267407089 -122.39663499597201 (37.718267407089, -122.396634995972)
1101 251439 3 67 49X Eddy St   1 1 2       3x3   6010285.0 2113564.0 37.78402382830029 -122.408117626865 (37.7840238283003, -122.408117626865)
94572 98483 1 67 531X Franconia St 8 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
95056 98485 1 67 531X Franconia St 10 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
139243 98475 1 67 531X Franconia St 2 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
143298 98479 1 67 531X Franconia St 4 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
143504 98481 1 67 531X Franconia St 6 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
144928 98487 1 67 531X Franconia St 12 1 1 2     3 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
Powered by Datasette · Query took 3.322ms · Data source: data.sfgov.org