sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2582 253132 2 70 522 Avalon Ave 6 1 1 1       Width 3ft   6004047.94044 2092448.5749599999 37.7256946506667 -122.428190247706 (37.7256946506667, -122.428190247706)
22706 7127 3 70 300X Fern St 6 1 1 2   02/02/1990 12:00:00 AM 6 3x3   6005701.71486 2115022.2576200003 37.7877701517306 -122.424077883603 (37.7877701517306, -122.424077883603)
35121 125494 2 70 1207 Chestnut St 6 9 1 1     3 Width 3ft   6006034.74479 2120336.40198 37.8023802517163 -122.423303571803 (37.8023802517163, -122.423303571803)
40963 125473 2 70 655 Powell St 6 9 1 1     4 Width 2ft   6010077.67437 2116003.04391 37.7907092485717 -122.409007053757 (37.7907092485717, -122.409007053757)
42654 125464 2 70 887 Eddy St 6 9 1 1     11 Width 4ft   6006280.54306 2113153.33425 37.782671211560704 -122.4219424317 (37.7826712115607, -122.4219424317)
60021 249949 2 70 303 Filbert St 6 17 1 1     14 Width 0ft   6011354.62644 2120055.4997 37.801907763195 -122.404874279527 (37.801907763195, -122.404874279527)
60116 248097 2 70 8 Brewster St 6 1 1 1     2 Width 2ft   6010442.71302 2099823.47595 37.7463043033989 -122.406603382656 (37.7463043033989, -122.406603382656)
67177 249537 2 70 201 Myrtle St 6 4 1 1     5 Width 3ft   6006345.87488 2114047.3209700002 37.7851295641198 -122.421779931396 (37.7851295641198, -122.421779931396)
67240 125498 2 70 1154 Chestnut St 6 9 1 1     8 Width 2ft   6006270.07079 2120429.11585 37.8026480985929 -122.422495818752 (37.8026480985929, -122.422495818752)
70001 175158 2 70 229 Delano Ave 6 9 1 1     1 Width 4ft   6000088.06493 2092305.57905 37.7250771680567 -122.44186892971399 (37.7250771680567, -122.441868929714)
77169 34187 1 70 2701 Lake St 6 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38079 5987120.3446635 2114449.05125045 37.785129669395104 -122.488322923297 (37.7851296693951, -122.488322923297)
80299 28777 3 70 365 Austin St 6 1 1 2     12 3X3   6005518.5465766 2115307.531712 37.788543099973396 -122.424731913891 (37.7885430999734, -122.424731913891)
103041 16943 3 70 599X Oak St 6 5 1 2     12 3x3   6004143.777734599 2110082.9014722 37.774119822677996 -122.429115732545 (37.774119822678, -122.429115732545)
119818 99405 1 70 2200X Keith St 6 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014766.6 2092880.6 37.7274815503989 -122.391166558925 (37.7274815503989, -122.391166558925)
122310 16400 1 70 299X Myrtle St 6 1 1 1   04/13/2005 12:00:00 AM 3 3X3   6006028.760559999 2113989.39072 37.7849526140265 -122.422872930887 (37.7849526140265, -122.422872930887)
149721 125500 2 70 12 Hastings Ter 6 9 1 1     2     6007269.76384 2119273.06582 37.7995302219096 -122.41895432719299 (37.7995302219096, -122.418954327193)
168469 125534 2 70 11 Miller Pl 6 1 1 1     3 Width 2ft   6010079.0906 2116883.16981 37.793125940953004 -122.409064282098 (37.793125940953, -122.409064282098)
184956 249990 2 70 228 Filbert St 6 7 1 1     2 Width 0ft   6011580.18498 2120103.15607 37.802051221233 -122.404097092619 (37.802051221233, -122.404097092619)
Powered by Datasette · Query took 7.457ms · Data source: data.sfgov.org