sf-trees

Data source: data.sfgov.org

Custom SQL query returning 12 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
31001 176999 2 27 906 Edinburgh St 2 1 1 1     1 Width 6ft   6001595.86635 2088796.01268 37.7155264893371 -122.436405562669 (37.7155264893371, -122.436405562669)
35498 129498 2 27 855 Chestnut St 7 9 1 1     20 Width 6ft   6007778.02269 2120584.45961 37.803159586216395 -122.417288546245 (37.8031595862164, -122.417288546245)
54071 207232 2 27 226 Thrift St 1 10 1 1     2 Width 6ft   5994766.53745 2089660.64097 37.7175101320775 -122.46007322780301 (37.7175101320775, -122.460073227803)
59888 177028 2 27 164 Baltimore Way 2 2 1 1     7 Width 6ft   6002357.56159 2086195.5289200002 37.7084293823926 -122.433587065817 (37.7084293823926, -122.433587065817)
59995 226605 2 27 276 Bemis St 2 9 1 1     6 Width 6ft   6002989.382569999 2096277.75645 37.7361487649474 -122.432122925433 (37.7361487649474, -122.432122925433)
70030 177026 2 27 501 Sweeny St 1 9 1 1     3 Width 6ft   6008206.81715 2094351.9900900002 37.7311554564421 -122.41394787781601 (37.7311554564421, -122.413947877816)
116496 177009 2 27 425 Cayuga Ave 2 9 1 1     7 Width 6ft   6002141.25462 2093891.34658 37.729548108055 -122.434884635528 (37.729548108055, -122.434884635528)
135933 176997 2 27 131 Farragut Ave 1 9 1 1     3 Width 6ft   5997268.75573 2087384.8014900002 37.7114048037631 -122.451260209013 (37.7114048037631, -122.451260209013)
162033 129497 2 27 855 Chestnut St 6 9 1 1     16 Width 6ft   6007750.73846 2120580.85704 37.803148159410604 -122.417382708871 (37.8031481594106, -122.417382708871)
166888 207141 2 27 1832 17th Ave 1 9 1 1     7 Width 6ft   5990964.44749 2102904.31775 37.7536544876696 -122.474180983561 (37.7536544876696, -122.474180983561)
168553 191409 2 27 1201 20th St 6 9 1 1     1 Width 6ft   6014316.155809999 2104772.8809 37.760110260198495 -122.39355571261999 (37.7601102601985, -122.39355571262)
182658 129487 2 27 3310 Baker St 1 9 1 1     9 Width 6ft   5999338.381580001 2120194.27566 37.8016098133151 -122.446465960942 (37.8016098133151, -122.446465960942)
Powered by Datasette · Query took 3.539ms · Data source: data.sfgov.org