Trying to keep attachments after a spatial join

942
11
09-27-2021 12:30 PM
Labels (1)
Marie-JoëlleDesgagné
New Contributor III

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 !

0 Kudos
11 Replies
DavidPike
MVP Frequent Contributor

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).

0 Kudos
Marie-JoëlleDesgagné
New Contributor III

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. 

0 Kudos
DavidPike
MVP Frequent Contributor

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?

0 Kudos
Marie-JoëlleDesgagné
New Contributor III

Yes, sure, thanks a lot for you help.

This is the original feature class with the attachments: Points_ISA_2020

MarieJolleDesgagn_5-1632842177739.png

 

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

MarieJolleDesgagn_6-1632842343618.png

 

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

MarieJolleDesgagn_8-1632842473179.png

 

MarieJolleDesgagn_9-1632842511630.png

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). 

MarieJolleDesgagn_10-1632842637437.png

 

And the result : no attachment!

MarieJolleDesgagn_11-1632842708956.png

Here is a screenshot of what my GDB looks like:

MarieJolleDesgagn_12-1632842776760.png

 

Thank you for your time !

MJ

 

 

0 Kudos
DavidPike
MVP Frequent Contributor

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

0 Kudos
Marie-JoëlleDesgagné
New Contributor III

Everything from the two tables, isn't strange?

MarieJolleDesgagn_0-1632845435456.pngMarieJolleDesgagn_1-1632845500923.png

MarieJolleDesgagn_2-1632845535080.png

 

0 Kudos
DavidPike
MVP Frequent Contributor

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

0 Kudos
Marie-JoëlleDesgagné
New Contributor III

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

0 Kudos
Marie-JoëlleDesgagné
New Contributor III

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.

0 Kudos