sf-trees

Data source: data.sfgov.org

Custom SQL query returning 11 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
29244 215411 2 31 1939 16th Ave 1 1 1 1     10 Width 2ft   5991245.12391 2102202.13663 37.7517427376545 -122.473159145982 (37.7517427376545, -122.473159145982)
30518 179954 2 31 40 Tomaso Ct 1 4 1 1     23 Width 2ft   6009197.20014 2086405.9588 37.709392885454 -122.409963207553 (37.709392885454, -122.409963207553)
146364 179967 2 31 716 Peru Ave 8 9 1 1     9 Width 2ft   6005275.29843 2092450.03888 37.7257680389529 -122.423947466603 (37.7257680389529, -122.423947466603)
147184 215439 2 31 217 Staples Ave 6 1 1 1     13 Width 2ft   5998709.4181699995 2093777.72882 37.729040692553 -122.44674062198 (37.729040692553, -122.44674062198)
152480 241225 2 31 4049 17th St 1 1 1 1     7 Width 2ft   6001920.58101 2105839.72544 37.7623430070574 -122.43650238277901 (37.7623430070574, -122.436502382779)
157728 215438 2 31 217 Staples Ave 5 1 1 1     11 Width 2ft   5998696.43814 2093778.97623 37.7290433761531 -122.44678558449101 (37.7290433761531, -122.446785584491)
159781 197990 2 31 155 Grace St 3 1 1 1     6 Width 2ft   6008384.453919999 2110216.9376 37.774726996282 -122.414455930021 (37.774726996282, -122.414455930021)
175537 136749 2 31 1360 Jones St 4 9 1 1     8 Width 2ft   6008500.72583 2117239.96883 37.794017078290295 -122.41455079677701 (37.7940170782903, -122.414550796777)
178324 215437 2 31 217 Staples Ave 4 1 1 1     12 Width 2ft   5998668.44451 2093778.0926299999 37.729039350777 -122.44688229669701 (37.729039350777, -122.446882296697)
185205 179966 2 31 716 Peru Ave 4 9 1 1     10 Width 2ft   6005255.40982 2092462.4838400001 37.725801087223 -122.424017104714 (37.725801087223, -122.424017104714)
185349 179968 2 31 675 Silver Ave 3 9 1 1     32 Width 2ft   6005852.39602 2093589.2328700002 37.7289285803821 -122.422033372066 (37.7289285803821, -122.422033372066)
Powered by Datasette · Query took 5.102ms · Data source: data.sfgov.org