topic Re: How do I query all features that do not have a attachment on ArcOnline? in ArcGIS Online Questions

How do I query all features that do not have a attachment on ArcOnline?

PatrickGrogan-Myers — Wed, 02 Oct 2019 15:20:55 GMT

I am currently working on a housing survey for the city. I want to pull all features that do not have an attachment to make sure that we get a picture of each house in the city. Is this possible?

Re: How do I query all features that do not have a attachment on ArcOnline?

alex_friant — Wed, 02 Oct 2019 18:06:42 GMT

I'd say it's possible with some python for the arcgis api. https://developers.arcgis.com/python/guide/using-attachments-with-feature-layers/

Rough sketch of how to:

Loop through all records in your hosted feature layer
Query each record to see if it has an attachment
Build an array logging all records which have zero attachments
Put that array into a target table of your choice so you can use in your workflow

Re: How do I query all features that do not have a attachment on ArcOnline?

Anonymous User — Wed, 02 Oct 2019 18:12:20 GMT

Hi Patrick Grogan-Myers‌,

Using a definition expression that queries all the object id's with Query Attachments can return all the features that have attachments: Query Attachments (Feature Service/Layer)—ArcGIS REST API: Services Directory | ArcGIS for Developers. Once you have those object id's you could feasibly list them and then query the layer for object id's not equal to those in the list. I have not tried this second part myself so I'm not 100% sure if it would work or not.

Another option is to use Arcade to filter the features without attachments in a Web Map. This is explained on this GeoNet blog. See Part 1: Calculate the attachment ID - except the filter in step 4 would be CountAttachments equals 0.

I'm thinking Arcade might be the better option here as it will allow you to see the location of houses without pictures right off the bat. Hope this helps!

-Peter

Re: How do I query all features that do not have a attachment on ArcOnline?

ChristopherMcClain — Wed, 02 Oct 2019 18:18:11 GMT

check this article out I found it very helpful for doing a very similar task.

Visualize your attachments in ArcGIS Online with Arcade