topic Re: Add Join duplicating OIDs ArcGIS Pro in Geoprocessing Questions

Add Join duplicating OIDs ArcGIS Pro

NataliaGutierrez1 — Thu, 15 Nov 2018 22:42:35 GMT

Hello,

I am using the Add Join tool to join a File Geodatabase Feature Class attribute table to another File Geodatabase Feature Class using parcel ID as the common field.

After the join I end up with more features than the original File Geodatabase Feature Class (Original 245,146, after the join 245,149) and I get this message next to the total number of features in a yellow triangle at the bottom of the attribute table after the join has been made: "You have duplicate OIDs in this table as a result of the join. The selection count is for unique OIDs, the total count is for all rows." (please see attached picture named Add_Join)

I tried both with the unchecked "Keep All Target Features" and checking it but both ave me the same result.

I used the Copy Features tool to make the join permanent and the extra features were still there. (Please see picture named Export_Features).

1. I would like to identify the extra features that were added with the join and why this is happening.

2. How to avoid this from happening ?

Note: I was not having this problem when I was joining shapefile feature classes to file geodatabase feature classes. I cannot keep on doing it this way because it was taking too long (days) to process.

I am guessing I was not having this problem with shapefiles because shapefiles use FID instead of OBJECTID?

I would appreciate someone to help me with this matter,

thanks,

Re: Add Join duplicating OIDs ArcGIS Pro

DanPatterson_Retired — Thu, 15 Nov 2018 23:00:11 GMT

I am not seeing this behaviour in your joined table

In the resulting layer or table view, the fields from the input layer or table view will be prefixed with the input's name and a period (.), and all fields from the join table will be prefixed with the join table name plus a period as the default.

Re: Add Join duplicating OIDs ArcGIS Pro

NataliaGutierrez1 — Thu, 15 Nov 2018 23:14:54 GMT

I do not understand your comment. Could you explain a bit more please.

Thanks!

Re: Add Join duplicating OIDs ArcGIS Pro

NataliaGutierrez1 — Thu, 15 Nov 2018 23:28:03 GMT

This is the file Geodatabase Feature Class Attribute Table with the joined fields already:

Re: Add Join duplicating OIDs ArcGIS Pro

DanPatterson_Retired — Thu, 15 Nov 2018 23:37:17 GMT

Add Join—Data Management toolbox | ArcGIS Desktop

your table isn't showing the prefixing.

Re: Add Join duplicating OIDs ArcGIS Pro

JoeBorgione — Fri, 16 Nov 2018 12:37:29 GMT

Prior to your join, perform a summary table on parcel id field in both tables. Sort them on the count field and see if there are any repeats (count > 1) I'm just trying to establish if there is a one to one relationship between the two tables, of if there is a many to one or one to many situation. Admittedly, this may be a reach based on too little caffine at this early hour...

Re: Add Join duplicating OIDs ArcGIS Pro

NataliaGutierrez1 — Fri, 16 Nov 2018 16:52:09 GMT

Dan,

This is the attribute table after being exported with the Show field aliases toggle turned off.

Things to have in mind:

1. The table being joined has more features than the original table.

2. I just want to keep the number of features on the original.

3. I am using Parcel ID as the unique field.

Re: Add Join duplicating OIDs ArcGIS Pro

NataliaGutierrez1 — Fri, 16 Nov 2018 17:23:49 GMT

Joe,

There are more parcel IDs on the table I am joining than the one I am joining to.

I just don't know why it adds more features.. I am not sure if it is repeating parcel ID's or why is this happening and how do I identify the ones being repeated.

Re: Add Join duplicating OIDs ArcGIS Pro

JoeBorgione — Fri, 16 Nov 2018 17:57:23 GMT

There are more parcel IDs on the table I am joining than the one I am joining to.

And are there any repeats of those parcel IDs in that table?

Re: Add Join duplicating OIDs ArcGIS Pro

NataliaGutierrez1 — Fri, 16 Nov 2018 18:07:53 GMT

Joe,

I just run a frequency on the parcel ID field and discovered that there are 2 parcel ID repeated twice:

Should I delete the ones repeated and leave only 1 per parcel ID and that should solve the problem?

Re: Add Join duplicating OIDs ArcGIS Pro

JoeBorgione — Fri, 16 Nov 2018 18:19:42 GMT

This is a good start: is what you show above the in_layer or the join_table? (target or source). When I look over at the Shape_Length and Shape_Area values, sirens go off in my head: those are really tiny parcels. Seem like sliver polygons to me...

Re: Add Join duplicating OIDs ArcGIS Pro

NataliaGutierrez1 — Fri, 16 Nov 2018 19:52:36 GMT

That is the table I am joining to the table I want to keep.

I guess the join_table.

And yes, these parcels are tiny ...

Re: Add Join duplicating OIDs ArcGIS Pro

JoeBorgione — Fri, 16 Nov 2018 19:58:08 GMT

See if those parcel id's appear more than once in the target table/feature class. I'll leave it up to to delete anything in your data.

Re: Add Join duplicating OIDs ArcGIS Pro

NataliaGutierrez1 — Fri, 16 Nov 2018 20:09:28 GMT

I am not sure if I understand what you mean... Sorry could you explain further

Re: Add Join duplicating OIDs ArcGIS Pro

JoeBorgione — Fri, 16 Nov 2018 22:08:04 GMT

Somewhere your data is being duplicated: you should examine the data you are joining to; you've already discovered some repeats in the data your are joining (from). You are getting a many to one join and that is goofing up your expected results. To me, the data you displayed earlier is erroneous. No one has a parcel that small. Make a copy of your data. Always make a copy of your data before you follow my lead! Delete those slivers, perform the join and see what your results are. But like I said, look at the other table/feature class you are joining to first.

Re: Add Join duplicating OIDs ArcGIS Pro

DanPatterson_Retired — Fri, 16 Nov 2018 22:10:34 GMT

can we get back to the getting rid of 'show hide' the alias? We need to determine WHERE that extra OBJECTID came from and what it belongs to. it isn't a duplicate if it belongs to another table, check my post way way up the one with the picture

Re: Add Join duplicating OIDs ArcGIS Pro

JamalNUMAN — Tue, 06 Apr 2021 17:53:52 GMT

Pro manages to duplicate features according to their corresponding values when performing the “add join” tool as per the screenshot below. I think this capability is enhanced in Pro