Skip to main content
Question

merge multiple file geodatabase tables

  • January 15, 2016
  • 3 replies
  • 213 views

sunsilk11
Contributor
Forum|alt.badge.img+6

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?

3 replies

davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • January 15, 2016

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.


davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • January 15, 2016
davideagle wrote:

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


erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • January 15, 2016

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings