nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Syntax for timeFilter

NathanDaniels

I am wondering if there is any sample code for the ArcREST timeFilter. I understand that it should be in Unix millisecond format. While the following line of code compiles in Python it returns the same number of records that I get without the timeFilter:

data = (fl.query(where="1=1", timeFilter="1482105600000") )

What I would like to get is only those records after that epoch time-stamp. Is my syntax correct? How would I also specify between a start and end time?

Trouver plus de publications taguées avec

Accepted answers

All comments

RandyBurton

Using the ArcREST modules on github, your code would be:

<SPAN class="comment token"># create a time filter object</SPAN>
tf <SPAN class="operator token">=</SPAN> TimeFilter<SPAN class="punctuation token">(</SPAN>start_time<SPAN class="operator token">=</SPAN><SPAN class="number token">123</SPAN><SPAN class="punctuation token">,</SPAN> time_zone<SPAN class="operator token">=</SPAN><SPAN class="string token">"UTC"</SPAN><SPAN class="punctuation token">,</SPAN> end_time<SPAN class="operator token">=</SPAN><SPAN class="number token">456</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># or start and end times</SPAN>
tf <SPAN class="operator token">=</SPAN> TimeFilter<SPAN class="punctuation token">(</SPAN><SPAN class="number token">123</SPAN><SPAN class="punctuation token">,</SPAN> end_time<SPAN class="operator token">=</SPAN><SPAN class="number token">456</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># or just a start time</SPAN>
tf <SPAN class="operator token">=</SPAN> TimeFilter<SPAN class="punctuation token">(</SPAN><SPAN class="number token">123</SPAN><SPAN class="punctuation token">)</SPAN>

data <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>fl<SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"1=1"</SPAN><SPAN class="punctuation token">,</SPAN> timeFilter<SPAN class="operator token">=</SPAN>tf<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># or</SPAN>
data <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>fl<SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"1=1"</SPAN><SPAN class="punctuation token">,</SPAN> timeFilter<SPAN class="operator token">=</SPAN>TimeFilter<SPAN class="punctuation token">(</SPAN>start_time<SPAN class="operator token">=</SPAN><SPAN class="number token">123</SPAN><SPAN class="punctuation token">,</SPAN> end_time<SPAN class="operator token">=</SPAN><SPAN class="number token">456</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

It does not appear that "time_zone" is implemented in the TimeFilter class. You may need to adjust the time stamp (Unix millisecond format) to the database's time zone if it is UTC or something other than your local time.

RandyBurton

Perhaps the "time" or "timeFilter" is for working with the archive class. Working directly with the archive class mentions "If you are interested in seeing a specific feature at a specific time, refer to its object ID and enter the appropriate date and time."

NathanDaniels

The timeFilter I am referring to is in the query section of this documentation:

http://esri.github.io/ArcREST/arcrest.ags.html

It would seem that timeFilter is an object where a UTC timestamp in milliseconds can be passed to it, but correct me if I’m not interpreting the docs right.

RandyBurton

I had made the assumption the date/time field name you were querying against was called "timeFilter". Use whatever name this field is called. You do not need to list it in the outFields if you are not interested in seeing or using it, likewise, you can sort (or not) on it or another field.

NathanDaniels

In the python snippet it specifies timeFilter in the outFields. Does this mean that there needs to be a field called timeFilter? How does the filter know which field to look at: CreationDate, EditDate etc.?

RandyBurton

Here's a Python snippet to demonstrate:

<SPAN class="comment token"># your url, something like:</SPAN>
URL <SPAN class="operator token">=</SPAN> <SPAN class="string token"><SPAN>"</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fservices.arcgis.com%2F" target="_blank">https://services.arcgis.com/</A><SPAN><abc123>/arcgis/rest/services/<myFeatureLayer>/FeatureServer/0/query"</SPAN></SPAN>

query_dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"where"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"1=1 AND timeFilter BETWEEN DATE '2016-12-19 00:00:00' AND DATE '2016-12-21 00:00:00'"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"outFields"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"OBJECTID, timeFilter, Field1, Field2, FieldN"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"orderByFields"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"timeFilter"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"returnGeometry"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"true"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"f"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"json"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"token"</SPAN><SPAN class="punctuation token">:</SPAN> token<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'token'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token"># results in json format</SPAN>
jsonResponse <SPAN class="operator token">=</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>URL<SPAN class="punctuation token">,</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>query_dict<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
features <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>loads<SPAN class="punctuation token">(</SPAN>jsonResponse<SPAN class="punctuation token">.</SPAN>read<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; object_pairs_hook<SPAN class="operator token">=</SPAN>collections<SPAN class="punctuation token">.</SPAN>OrderedDict<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN>u<SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

Try:

1=1 AND timeFilter >= '2016-12-19 00:00:00'‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

1=1 AND timeFilter BETWEEN '2016-12-19 00:00:00' AND '2016-12-21 00:00:00'‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

If the response format is JSON, then you will need to convert any returned date/time fields from Unix millisecond format. However for the query text, you will want to use a time string such as above, but something like '12/19/16' may also work. You may also wish to use the DATE keyword before your date/time string.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.