topic Re: Merging features in an enterprise geodatabase in ArcGIS Pro Questions

Merging features in an enterprise geodatabase

Michele — Sun, 13 Oct 2024 17:12:40 GMT

I have 2 records in the attribute table of a feature class contained in a non-versioned enterprise gdb that I want to merge into one. I've done this before without an issue but this time when I select the merge tool from modify features I get an error message at the top that says "the destination layer type cannot be merged" and the merge button at the bottom is grayed out. Anyone know why this is and how to get around it?

Re: Merging features in an enterprise geodatabase

Eugene_Adkins — Mon, 14 Oct 2024 02:33:26 GMT

When you say “2 records” do you mean two features or literally two records?

If they are records and not features this may be the cause of the issue. If they are shapes and not records, make sure they are the same shape/geometry type (point merged with point, etc.). If you are working with a feature and record (that does not accompany an actual feature), the existing feature may not allow a merge with a record which would result in a “null” geometry.

If you are actually working with records, maybe this post will help.

Re: Merging features in an enterprise geodatabase

Michele — Mon, 14 Oct 2024 03:26:54 GMT

I mean 2 rows in the same attribute table of 1 feature class that have the same exact attributes in each field (column). I guess they are technically features and they are in a polygon feature class. I’m just trying to combine like rows of the same attributes into 1 row instead of having multiple rows. The merge features edit tool usually works but for some reason I am getting that error message when I add that SDE layer into the GP tool. I can’t even attach a screen shot bc it’s on a network that’s not connected to the internet.

Hope that clarifies it. It’s tough to explain with just words.

Re: Merging features in an enterprise geodatabase

Eugene_Adkins — Mon, 14 Oct 2024 03:43:27 GMT

Understood.

Just for clarification, the feature class you’re working with is straight from the database or is sourced from a feature service (a published editable service) and not a map service, correct?

Re: Merging features in an enterprise geodatabase

Michele — Mon, 14 Oct 2024 03:54:29 GMT

Yes. Straight from the database. It also has a feature service and possibly a map service created from it. I can’t recall off the top of my head. Perhaps that’s why?? We don’t use arc online to edit anything. It’s just there for users to use or add into their project. Maybe if I try to merge it before I append it to the database that would work. I think that’s what I was doing in the past. A feature was left out a few weeks ago and I was trying to add it after the fact then merge it, but I guess I can’t do that in an sde that has services. I’ll have to try that on Tuesday. Thanks for talking this through with me. Sometimes that’s all you need to figure it out. 🙂