sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
8932 19577 3 42 100 STAIRWAY3 2 1 1 2     3 15ST            
15903 20055 3 42 100 STAIRWAY54 2 1 1 2     6 15ST            
19917 28134 3 42 400X Eugenia Ave 2 1 1 2   08/17/2016 12:00:00 AM 3 6x9   6006749.04287 2098002.24216 37.741096261078404 -122.41924650972 (37.7410962610784, -122.41924650972)
77429 23663 3 42 311 Virginia Ave 2 11 1 2     12 12   6006938.1768512 2098312.3803834 37.7419584813283 -122.41861453896999 (37.7419584813283, -122.41861453897)
86900 19282 3 42 1770 Scott St 2 1 1 2     11 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
91582 23671 3 42 317 Virginia Ave 2 11 1 2     6 12   6006937.941544901 2098264.8464559 37.7418279505329 -122.41861198258002 (37.7418279505329, -122.41861198258)
124870 98708 2 42 105X Ord St 2 1 1 2           6000883.6 2105740.8 37.7620124016568 -122.440081810476 (37.7620124016568, -122.440081810476)
128008 23660 3 42 305 Virginia Ave 2 11 1 2     12 12   6006899.0385805 2098362.9679323 37.742095179874795 -122.418753453583 (37.7420951798748, -122.418753453583)
140403 1378 3 42 65 Amethyst Way 2 1 1 2   04/10/1998 12:00:00 AM 7 1X1   5998886.878159099 2099985.9166978 37.746097033504896 -122.44657360851801 (37.7460970335049, -122.446573608518)
Powered by Datasette · Query took 8.889ms · Data source: data.sfgov.org