Re-assign Spatial Data to a Point Layer

Basically, I exported a point feature class table to MS Access and removed duplicates within the data. The point feature class had had its points assigned spatially, based on ObjectID. Now, I need to reassign spatial data to the table (duplicates removed). Does anyone have any ideas on this?

Do you have ArcGIS 10 SP3? We added two tools, Find Identical and Delete Identical, and fixed some bugs in the SP3. You could use these tools to find or remove duplicated features without going through Access.

To answer your question, you would need to have a common attribute as the "join field" in order to join the tables together by either the Add Join tool or Join Field tool. You should have such attribute created before exporting to Access so it becomes "common" to both tables.

Do you have ArcGIS 10 SP3? We added two tools, Find Identical and Delete Identical, and fixed some bugs in the SP3. You could use these tools to find or remove duplicated features without going through Access.

To answer your question, you would need to have a common attribute as the "join field" in order to join the tables together by either the Add Join tool or Join Field tool. You should have such attribute created before exporting to Access so it becomes "common" to both tables.

Dan, thanks for the response. Unfortunately, I don't have the proper license to use the Delete Identical tool, though it would have made my task 100x easier.As for joining, please bear with me because I'm remarkably unfamiliar with this process. Specifically, can you tell me how to populate my point feature class with the attributes in the table? Each time I try, my feature class table remains completely empty. Is it easier to do this by creating a new point feature class from scratch?

Can you give more complete description of your dada and what you are trying to do? Did you mean you have coincident points (duplicates spatially)? Are they clusters? If each set of duplicated points are coincident points and they are apart from other sets of points, you can try Integrate tool with a small tolerance. A set of coincident points within that tolerance will "snap" together to become one point, as if the duplicates are removed. This tool modifies the input; make a backup copy and do a small test area first to understand what the tool does. If this works for you, then you can avoid using Access.

If that doesn't work for you, either you need to describe your case in more detail or share a sample data so we can understand the situation. I am afraid if I say more I might confuse or mislead you.

Can you give more complete description of your dada and what you are trying to do? Did you mean you have coincident points (duplicates spatially)? Are they clusters? If each set of duplicated points are coincident points and they are apart from other sets of points, you can try Integrate tool with a small tolerance. A set of coincident points within that tolerance will "snap" together to become one point, as if the duplicates are removed. This tool modifies the input; make a backup copy and do a small test area first to understand what the tool does. If this works for you, then you can avoid using Access.

If that doesn't work for you, either you need to describe your case in more detail or share a sample data so we can understand the situation. I am afraid if I say more I might confuse or mislead you.

Dan, sorry for the lack of information.

Specifically, my end goal is an AutoComplete table for use within a search. The original AutoComplete table (1) has approximately 191,000 records; I need to add about 1,000 more. The other table (2) that I appended to the original AutoComplete table contained about 40,000 values identical to those already in the original PLUS the 1,000 unique values I need (i.e. Table 1 + Table 2 = 192,000 unique records AND 40,000 duplicates). So, my process has been to remove the duplicates so I may wind up with my 192,000 unique records.

As I said, I've been able to elminate the duplicates using MS Access. The problem I'm now dealing with is re-assigning the spatial data to the new AutoComplete Table (3). The former tables were both taken from point feature classes, but they themselves do not contain x/y values. I've been trying to create a join between the latter table (3) and the former table (2), but that's not working like I want it to. All I really need to do is get the points in my new table (3) geospatially plotted.

Is there someway to extract x/y values from a point feature class? Is what I'm trying to do even within the realm of possibility??

I hope that description isn't too complex, but I tried to be as specific as possible. Any advice is still appreciated!

Here is my question for you: why did you Append the duplicated features (Table2) into the unique features (Table1)? Did you want to replace the duplicated features inTable1 by the ones in Table2 because features in Table2 have better attributes or other reasons? If that is the case, perhaps you could try the following:1. Use Select By Location tool to select features from Table1 that "Intersect" with or are "Within a distance" to features in Table2. Check if the selected features match the features in Table2.2. Use Delete Features tool to delete the selected features from Table1.3. Then use Append to combine Table2 with Table1. Now you should have unique features in the resulting Table1.

If that is NOT the case, please explain more.

To answer your question about "to extract x/y values from a point feature class": you can use the Add XY Coordinates tool (Data Management toolbox - Features toolset).

Sorry for this delayed response, but I figured follow up could be helpful to someone else. I ended up sending my data to another user, who deleted the duplicates for me. If anyone else has this problem, I highly recommend doing the same. The work around is not worth it; it's just as well to try deleting them all by hand.

It is always interesting and appreciated to hear how one ends up solving the problem. I guess either your case is not what I thought by reading your descriptions or you ran into more complications. Anyway I am glad that you got some help.