Hi I have a large number of file geodatabases with one feature class in each.
I would like to merge all the feature classes and save in one single file geodatabase.
Any suggestions what's the best way to achieve this?
Question
merge multiple file geodatabase tables
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+21- Contributor
Hi there - just add a Geodatabase Reader (ArcObjects if you have ESRI installed and API reader if not). Then browse to multiple GDB files at once like this:
...or go for c:\\temp\\**\\*.gdb or similar. Then make sure 'Single Merged Feature Type' is tagged.
Then add an AttributeExposer to your feature type and expose fme_basename (for the filename) and fme_feature_type (for the featureclass name) so that you know what came from where. You'll then be able to conflate the content to a single target GDB with a GDB writer.
+21- Contributor
Hi there - just add a Geodatabase Reader (ArcObjects if you have ESRI installed and API reader if not). Then browse to multiple GDB files at once like this:
...or go for c:\\temp\\**\\*.gdb or similar. Then make sure 'Single Merged Feature Type' is tagged.
Then add an AttributeExposer to your feature type and expose fme_basename (for the filename) and fme_feature_type (for the featureclass name) so that you know what came from where. You'll then be able to conflate the content to a single target GDB with a GDB writer.
Something like this perhaps. filegdb2filegdb.fmw
+26- Contributor
DO you want to merge the feature classes into one new feature class?
Or do you want to add all feature classes into one new file geodatabase?
David answered the first option.
If the second is what you need:
Use the reader as David suggested but do not merge feature types, just use individual feature types.
Add a Writer to a new File geodatabase and use the option to copy from reader.
This will make a copy of all tables into a new file geodatabase.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.