Best field/method to use to attach multiple photos to features

twilliamson_topv

Hello.

I had previously set up attachments for a feature class of art for my town. It is seeming that our arts department is going to want to be able to have multiple photos for some of these features.

Before, I had simply used the OBJECTID as the Input Join Field and then had the photos named to match this. For example, OBJECTID 1 had an attachment from a folder of art photos and the corresponding photo in that folder was named "1". 

I'm thinking this will not work for multiple photos per feature. I have attached a screenshot of the current attribute table. 

What would be the best way of going about this?

The final product is going to be an ArcGIS StoryMap Map Tour for this art. I know the City of Tempe has multiple photos set up for their art seen here: https://experience.arcgis.com/experience/878970f6a27d49c6872eea73b1bd65b9/page/Story-Map/

I would like to not need to do this one by one. 

Any help is greatly appreciated! 

TownArt1.png

DavidSolari

A few ways to do this, each with their own compromises:

1. Add multiple attachment fields and populate as many as you need. This is a bad data design practice because you now have a maximum attachment limit, and any feature without that maximum has a bunch of null data, but it can be a practical solution.
2. Create a table of attachment links and define a one to many relationship class from the art points to the attachment records. The main limit here is configuring your pop-ups to load in the photos in a user-friendly way regardless of how many there are, I'm stuck on Enterprise 11.1 so maybe someone else will come in with some pointers.
3. Use the standard ArcGIS attachment format on your feature class and load the photos in there. This has the best compatibility with web maps but it means a copy of your source data has to sit in a special database table.