Skip to main content
Solved

ArcGIS Portal filter features before downloading attachments


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

View original
Did this help you find an answer to your question?

2 replies

rahulsharma
Safer
Forum|alt.badge.img+10
  • Safer
  • 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


  • Author
  • June 29, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings