topic time filtering in ArcGIS API for Python in ArcGIS Online Questions

time filtering in ArcGIS API for Python

WPG03WPG03 — Fri, 16 Sep 2022 04:09:04 GMT

I am trying to query the layer by using time for filtering,

ref:(https://developers.arcgis.com/python/api-reference/arcgis.features.toc.html#featurelayer

ArcGIS API for Python -> arcgis.features module -> FeatureLayer -> query()

)

It is tried that the datetime of all return data from query() are +00:00,

is there a way to set timezone in the query? May be in sql-92 where clause, arcgis online session configuration to set timezone, or other ways to filter (e.g. time_filter option in query(), tried but seems failed to specify the datetime field), etc..

Re: time filtering in ArcGIS API for Python

jcarlson — Fri, 16 Sep 2022 15:09:12 GMT

Sorry, but what's the problem here? Is it that you want to query with a different time zone, or that the time filtering isn't working somehow? When you submit a query, it will read it in on your local time.

From the REST API docs (emphasis added):

For example, if you want to return all the records that match 1:00 p.m. on February 9, 2015, Pacific standard time, your WHERE clause would be as follows:
where=pacific_time_date_field = DATE '2015-02-09 13:00:00'
Although you issue local time in your WHERE clause, this operation always returns date values in UTC.