sf-trees

Data source: data.sfgov.org

Custom SQL query returning 13 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5195 253341 4 88 1935 46th Ave 1 5 1 1   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.6810099995 2101921.14451 37.750428327874204 -122.505299944249 (37.7504283278742, -122.505299944249)
3174 253344 4 88 2586 30th Ave 1 1 1 1   08/23/2017 12:00:00 AM 3 4x4 Permit Number 780063 5987098.36417 2097677.28593 37.7390777358027 -122.487166705945 (37.7390777358027, -122.487166705945)
9960 173748 4 88 1259 21st Ave 1 1 1 1   01/13/2017 12:00:00 AM 3 3x3 Permit Number 773489 5989520.0 2106786.0 37.764228762563896 -122.47946011839899 (37.7642287625639, -122.479460118399)
9719 173651 4 88 80 Entrada Ct 3 9 1 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
143274 122379 4 88 466 Vernon St 1 8 1 1   10/26/2016 12:00:00 AM 3 3x3   5992521.0 2090937.0 37.7208852925782 -122.46792773796801 (37.7208852925782, -122.467927737968)
82889 114908 4 88 281 LOBOS ST 1 1 1 1       3x3   5994225.0 2088676.0 37.714775380268996 -122.461873702271 (37.714775380269, -122.461873702271)
109947 120109 4 88 555 Ellington Ave 1 1 1 1   08/03/2016 12:00:00 AM 3 3x3   5997970.0 2087042.0 37.7105036758619 -122.44881186315901 (37.7105036758619, -122.448811863159)
3318 253415 4 88 55 Stoneybrook Ave   8 1 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
26519 115980 4 88 2x Olmstead St 5 1 1 1     1 3x3   6011593.71434 2091235.60939 37.722788156028706 -122.402019710862 (37.7227881560287, -122.402019710862)
171742 115979 4 88 2x Olmstead St 4 1 1 1     1 3x3   6011610.19593 2091240.25279 37.722801825729604 -122.401963063449 (37.7228018257296, -122.401963063449)
172623 115978 4 88 2x Olmstead St 3 1 1 1     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721001 (37.7228154963084, -122.40191601721)
182061 115977 4 88 2x Olmstead St 2 1 1 1     1 3x3   6011639.0005 2091249.90123 37.722829925953896 -122.40186416949 (37.7228299259539, -122.40186416949)
12646 115976 4 88 2x Olmstead St 1 1 1 1     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757)
Powered by Datasette · Query took 5.728ms · Data source: data.sfgov.org