topic Re: Trying to keep attachments after a spatial join in ArcGIS Pro Questions

Trying to keep attachments after a spatial join

Marie-JoëlleDesgagné — Mon, 27 Sep 2021 19:30:39 GMT

Hi,

I have a layer containing multiple attachment and when I do a spatial join, my attachments disappear. How could I make sure it is kept from my initial layer? I tried to add attachments but it is still not working. I also enabled the attachments to my spatial join layer.

Thank a lot !

Re: Trying to keep attachments after a spatial join

DavidPike — Mon, 27 Sep 2021 19:57:04 GMT

Possibly a table join between your new FC (without attachments) back to the old FC (with attachments), then make the join permanent with Copy or Feature Class to Feature Class Maintain Attachments (Environment setting)—ArcGIS Pro | Documentation

then clean-up duplicate fields etc. (or better to do this at the field mapping stage in the table join).

This is just a wild idea but maybe worth a go, as I don't see any issues with it theoretically (though not saying that there's not a better way I'm missing).

Re: Trying to keep attachments after a spatial join

Marie-JoëlleDesgagné — Tue, 28 Sep 2021 12:56:48 GMT

Joining the table to the FC with attachments work, but then when I try to make a copy or feature class to feature class, the joined part of the table won't join.

Re: Trying to keep attachments after a spatial join

DavidPike — Tue, 28 Sep 2021 14:30:43 GMT

Strange, it should export the joined features. Are you able to take some screenshots of the table and also the fieldmap and output from Feature Class to feature Class?

Re: Trying to keep attachments after a spatial join

Marie-JoëlleDesgagné — Tue, 28 Sep 2021 15:26:53 GMT

Yes, sure, thanks a lot for you help.

This is the original feature class with the attachments: Points_ISA_2020

This is the result of the spatial join (without attachment) : Points_ISA_2020spatialjoin

Then I joined Points_ISA_2020spatialjoin to Points_ISA_2020 and it adds the fields I want and still has the attachments:

But then when I try to make a permanent join, I tried to do a feature class to feature class but no success (I checked the Maintain attachment).

And the result : no attachment!

Here is a screenshot of what my GDB looks like:

Thank you for your time !

Re: Trying to keep attachments after a spatial join

DavidPike — Tue, 28 Sep 2021 16:06:08 GMT

hmmmm. What is shown in the 'Fields' dropdown in the FC to FC tool?

Re: Trying to keep attachments after a spatial join

Marie-JoëlleDesgagné — Tue, 28 Sep 2021 16:12:41 GMT

Everything from the two tables, isn't strange?

Re: Trying to keep attachments after a spatial join

DavidPike — Tue, 28 Sep 2021 16:41:53 GMT

Maybe it doesn't like your geodatabase, how about creating a new FGDB and retrying.

Re: Trying to keep attachments after a spatial join

Marie-JoëlleDesgagné — Tue, 28 Sep 2021 19:25:00 GMT

Already tried that, and still it does not work. I really don't understand what's happening.

Re: Trying to keep attachments after a spatial join

Marie-JoëlleDesgagné — Tue, 28 Sep 2021 19:27:58 GMT

I will try with another layer just to see if the problem comes from the layer itself, but other than that, I have no clue what else I could do haha.

Re: Trying to keep attachments after a spatial join

DavidPike — Tue, 28 Sep 2021 20:04:26 GMT

You've tried the copy tool also I think you said? What license level do you have? i.e. Basic, Standard, Advanced.

Re: Trying to keep attachments after a spatial join

Marie-JoëlleDesgagné — Tue, 28 Sep 2021 20:15:04 GMT

I also tried the copy tool yes. I my license is Advanced. I have version 2.8.3.

Re: Trying to keep attachments after a spatial join

l_al-sabbagh — Mon, 20 Jan 2025 14:38:26 GMT

Try using Add Spatial Join (Data Management) tool instead of using Spatial Join (Analysis) tool. Remember that the first tool offers a temporary join, meaning you'll need to export your feature class to save it in your geodatabase.