sf-trees

Data source: data.sfgov.org

Custom SQL query returning 11 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
36611 207332 2 27 139 Mangels Ave 1 9 1 1     3 Width 10ft   6000483.56606 2095198.0934400002 37.7330418734682 -122.44070911276 (37.7330418734682, -122.44070911276)
37207 207145 2 27 1418 14th Ave 2 9 1 1     3 Width 5ft   5991828.31268 2105750.01462 37.7615180292623 -122.471400907553 (37.7615180292623, -122.471400907553)
47592 207190 2 27 212 Hearst Ave 7 9 1 1     3     5999972.7522599995 2094392.56954 37.7308009895699 -122.44241731471399 (37.7308009895699, -122.442417314714)
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)
73643 207345 2 27 628 Edna St 1 9 1 1     3 Width 10ft   5998591.38299 2094890.7633 37.732090079596794 -122.44722875061399 (37.7320900795968, -122.447228750614)
133764 207351 2 27 662 Mangels Ave 1 9 1 1     3 Width 3ft   5997053.67683 2095305.7853299999 37.7331416469589 -122.45257485054701 (37.7331416469589, -122.452574850547)
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)
162797 207229 2 27 1162 Capitol Ave 1 9 1 1     3 Width 1ft   5995089.6840699995 2091648.0085099998 37.7229855509323 -122.459100089412 (37.7229855509323, -122.459100089412)
182796 207336 2 27 114 Melrose Ave 3 9 1 1     3 Width 10ft   5999335.46736 2095537.54616 37.7339084817781 -122.444702769016 (37.7339084817781, -122.444702769016)
185209 207231 2 27 250 Faxon Ave 1 9 1 1     3 Width 3ft   5994770.3606900005 2090247.29491 37.7191211640843 -122.46010248996099 (37.7191211640843, -122.460102489961)
188039 207335 2 27 114 Melrose Ave 2 9 1 1     3 Width 10ft   5999338.03809 2095537.4927400001 37.7339084817987 -122.444693877414 (37.7339084817987, -122.444693877414)
Powered by Datasette · Query took 58.808ms · Data source: data.sfgov.org