sf-trees

Data source: data.sfgov.org

Custom SQL query returning 12 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
63043 209019 2 103 33 Martha Ave 2 23 1 1     12     6000764.3171 2095528.5679900001 37.7339652640682 -122.43976216978201 (37.7339652640682, -122.439762169782)
32540 210191 2 50 321 Melrose Ave 1 23 1 1     12     5997966.64829 2095534.3479400002 37.7338214930658 -122.44943494048799 (37.7338214930658, -122.449434940488)
153234 209020 2 103 33 Martha Ave 4 23 1 1     12     6000767.68455 2095534.49854 37.7339817396554 -122.439750952547 (37.7339817396554, -122.439750952547)
31996 237002 2 16 199 Franconia St 11 23 1 1     12 Width 3ft   6010115.457330001 2099644.6115099997 37.745794866235 -122.40772238927 (37.745794866235, -122.40772238927)
54292 192358 2 10 1 25th St 2 23 1 1     12     6015008.12096 2102140.25985 37.752920069827 -122.39097851376499 (37.752920069827, -122.390978513765)
66873 196280 2 16 1 25th St 11 23 1 1     12     6015022.69172 2102195.1938 37.7530717153135 -122.39093196394501 (37.7530717153135, -122.390931963945)
130300 196281 2 16 1 25th St 12 23 1 1     12     6015018.372359999 2102200.19302 37.7530852024401 -122.39094725063102 (37.7530852024401, -122.390947250631)
137606 196282 2 16 1 25th St 13 23 1 1     12     6015015.25562 2102205.64875 37.75310000977571 -122.39095841029499 (37.7531000097757, -122.390958410295)
174582 189679 2 32 1 24th St 20 23 1 1     12     6017238.946959999 2102621.26617 37.7543643468473 -122.383297299846 (37.7543643468473, -122.383297299846)
170165 197469 2 213 1 24th St 3 23 1 1     12     6017071.17305 2102662.5786200003 37.7544685090175 -122.383880386982 (37.7544685090175, -122.383880386982)
178126 224454 2 40 4090 20th St 6 23 1 1     12 Width 3ft   6003124.6046 2104168.08557 37.7578214298263 -122.432218730236 (37.7578214298263, -122.432218730236)
138227 199545 2 224 1 01st St 1 23 1 1     12     6014356.43896 2105915.99545 37.7632512422621 -122.39349639336099 (37.7632512422621, -122.393496393361)
Powered by Datasette · Query took 2.951ms · Data source: data.sfgov.org