Workaround for tools "Select" and "Copy Features" in Model Builder

1170
2
Jump to solution
12-02-2013 04:32 AM
by Anonymous User
Not applicable
Original User: jofuchs

Hi all,

I want to copy all features from feature class A, which have the identical attributes (only of one specific column) of another feature class B.
I thought about first selecting the features with the select tool and an sql query and than copying the selection with copy features.
My problem is the correct sql code block. I need something like:

"Select all features from FC A, where the attribute "ID" is the same like "ID" in FC B"

Can you help me with this problem?

Many thanks in advance! Im also glad, if there is another workaround to solve the problem. 🙂
0 Kudos
1 Solution

Accepted Solutions
DaleHoneycutt
Occasional Contributor III
You need to first establish a join between the two feature classes.

See About joining and relating tables.

In geoprocessing, you'd use the Add Join tool.  After selecting features with the same ID value, use Copy Features.

View solution in original post

0 Kudos
2 Replies
DaleHoneycutt
Occasional Contributor III
You need to first establish a join between the two feature classes.

See About joining and relating tables.

In geoprocessing, you'd use the Add Join tool.  After selecting features with the same ID value, use Copy Features.
0 Kudos
by Anonymous User
Not applicable
Original User: jofuchs

Thank you for your hints. That is another workaround which worked fine!
0 Kudos