sf-trees

Data source: data.sfgov.org

Custom SQL query returning 15 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
28860 51570 1 36 227 24th Ave 1 1 1 1 1 02/04/2005 12:00:00 AM 17   Permit Number 47867 5988337.51894 2114460.53389 37.7852321378524 -122.48411277430401 (37.7852321378524, -122.484112774304)
148918 62209 1 36 227 24th Ave 1 1 1 1 1 10/12/1985 12:00:00 AM 16   Permit Number 22331 5988338.57879 2114482.10714 37.7852914335725 -122.48411069019699 (37.7852914335725, -122.484110690197)
183147 66382 1 36 661 Fillmore St 1 1 1 1 1 01/04/1991 12:00:00 AM 12   Permit Number 29508 6003420.5252 2110677.1492 37.7757105120941 -122.431660023451 (37.7757105120941, -122.431660023451)
116970 34459 1 36 1960 Jones St 1 1 1 1 1 12/21/2015 12:00:00 AM     Permit Number 42077 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
120244 34458 1 36 1960 Jones St 3 1 1 1 1 12/21/2015 12:00:00 AM   3x3 Permit Number 42077 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
125997 34460 1 36 1960 Jones St 2 1 1 1 1 12/21/2015 12:00:00 AM   3x3 Permit Number 38200 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
40659 62578 1 36 739 Vermont St 1 1 1 1 1 03/01/1986 12:00:00 AM 9   Permit Number 22783 6011302.7424099995 2104925.74778 37.7603620991639 -122.403988486898 (37.7603620991639, -122.403988486898)
62464 62579 1 36 741 Vermont St 1 1 1 1 1 03/01/1986 12:00:00 AM 10   Permit Number 22784 6011303.77085 2104898.93824 37.7602885436105 -122.40398304329399 (37.7602885436105, -122.403983043294)
57547 38224 1 36 1099 Mississippi St 1 1 1 1 1 10/05/2002 12:00:00 AM 14   Permit Number 40351 6014264.59569 2102044.43409 37.7526156672934 -122.39354307806101 (37.7526156672934, -122.393543078061)
78284 36808 1 36 1290 Egbert Ave 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39532 6014916.278192299 2090716.3266444001 37.721547191141205 -122.39049795372 (37.7215471911412, -122.39049795372)
95666 36809 1 36 1290 Egbert Ave 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39532 6014916.278192299 2090716.3266444001 37.721547191141205 -122.39049795372 (37.7215471911412, -122.39049795372)
83231 36833 1 36 2715 Ingalls St 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194)
146328 36834 1 36 2715 Ingalls St 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194)
89868 36789 1 36 1314 Donner Ave 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39526 6015468.42166203 2090653.62366449 37.7214056358126 -122.388584951991 (37.7214056358126, -122.388584951991)
117616 36790 1 36 1314 Donner Ave 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39526 6015468.42166203 2090653.62366449 37.7214056358126 -122.388584951991 (37.7214056358126, -122.388584951991)
Powered by Datasette · Query took 60.3ms · Data source: data.sfgov.org