Skip to main content
Solved

ArcGIS Portal filter features before downloading attachments

  • June 28, 2022
  • 2 replies
  • 22 views

pir
Participant
Forum|alt.badge.img+2
  • Participant
  • 3 replies

I would like to incrementally download features including attachments (jpg images) using the ArcGIS Portal feature Service Reader. I want to do this by filtering the feature creation date using a tester. This works fine but when I check the option to download the attachments, it takes an enormous amount of time. It's a large datset and I only want to download some of the most recently added data. Is there any way to perform the tester operation first before downloading the attachments?

Best answer by rahulsharma

Hi @pir​ 

Unfortunately, there is no way of performing any operation without having to read the data first.

However, as per ESRI documentation, you should be able to use the WHERE clause to query either the LAST EDITED or CREATION DATE attributes to get only the feature that fits the criteria using following

<DateField> >= CURRENT_TIMESTAMP - DD

Now, if you want to get all the features that were edited last week, you should be able to use a query similar to the one listed below.

"LAST EDITED"> CURRENT_TIME -7

NOTE: In FME, you will have to double-quote the attribute name, which is not required in ArcGIS Rest API.

Hope this helps

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

rahulsharma
Safer
Forum|alt.badge.img+10
  • Safer
  • 359 replies
  • Best Answer
  • June 28, 2022

Hi @pir​ 

Unfortunately, there is no way of performing any operation without having to read the data first.

However, as per ESRI documentation, you should be able to use the WHERE clause to query either the LAST EDITED or CREATION DATE attributes to get only the feature that fits the criteria using following

<DateField> >= CURRENT_TIMESTAMP - DD

Now, if you want to get all the features that were edited last week, you should be able to use a query similar to the one listed below.

"LAST EDITED"> CURRENT_TIME -7

NOTE: In FME, you will have to double-quote the attribute name, which is not required in ArcGIS Rest API.

Hope this helps


pir
Participant
Forum|alt.badge.img+2
  • Author
  • Participant
  • 3 replies
  • June 29, 2022

Thank you so much, this is exactly what I was looking for!