topic Re: How to merge 2 featureclasses and related attachments in Geodatabase Questions

How to merge 2 featureclasses and related attachments

MarkGiesbrecht2 — Fri, 03 Jun 2016 21:43:23 GMT

Hey Folks, I've beat the bush on this, and can't quite figure out all the details.

I have users who have collected features via Collector, uploaded photos, captured field comments, etc. Problem is, they had used two different (yet identical schema) layers to do so.

I have downloaded both data sets, and am now trying to figure out how to merge them into a single featureclass with all the related attachments. I've used the ArcMap -> Load Objects tool to get me closer, but the attachments don't come across. Tried ArcGIS 10.2.2, as well as 10.3.1.

Any ideas, or have I hit a limit of functionality?

Cheers
Mark

Re: How to merge 2 featureclasses and related attachments

LanceShipman — Fri, 03 Jun 2016 22:20:38 GMT

Try the Append geoprocessing tool. It worked in my testing.

Re: How to merge 2 featureclasses and related attachments

MarkGiesbrecht2 — Mon, 06 Jun 2016 15:04:05 GMT

Not sure what steps you did to verify, but when I ran the append on the feature class, only the point features came across, and not their attachments.

OSE_Site_Scouting_Observations -> OSE_Site_Scouting_Points

I also tried appending the features first, then the associated attachment table, but those do not map to the appended features.

OSE_Site_Scouting_Observations -> OSE_Site_Scouting_Points

OSE_Site_Scouting_Observations__ATTACH -> OSE_Site_Scouting_Points__ATTACH

Were you testing on a feature class that had a relationship class established with an __ATTACH table?

Re: How to merge 2 featureclasses and related attachments

LanceShipman — Mon, 06 Jun 2016 15:20:38 GMT

I checked the content content and row count of both _ATTACH tables before the APPEND and the target databasets _ATTACH table after the append. The target datasets _ATTACH has the correct number of rows. I also spot checked the attachments in ArcMap and the content of both tables is present. What version of ArcGIS are you using? I'll load a copy and check the behavior.

Re: How to merge 2 featureclasses and related attachments

MarkGiesbrecht2 — Mon, 06 Jun 2016 16:04:23 GMT

To clarify, the feature counts add up for both the __ATTACH table and the feature table. Problem is that for appended records, they do not show when identified in ArcMap, as I suspect the GlobalID's do not match for the newly added records.

I've tried both 10.2.2 and 10.3.1